Skip to main content
Question

Pipeline workaround - 'is contained within'

  • January 29, 2022
  • 0 replies
  • 52 views

Forum|alt.badge.img+20

How can I accomplish this in a Pipeline?

A- Search a table. Include a text field

that is a list of items (semicolon deliminator). This search yields a handful of results.

For each A:

B. Search a different table with this condition:
 

is contained within
.

Obviously that isn't a filter that exists. What ways can this concept be accomplished?



------------------------------
Mike Tamoush
------------------------------

MarkShnierYou
Forum|alt.badge.img+24
There is a Contains filter available in a Search. Can you explain why it can't be used?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Forum|alt.badge.img+4
Hi Mike,

If it is a semicolon delimiter you could try using regex, that is what I do for multi-select fields:

Find All Matches to Regex:
Text: {{yourfield}}
Regular Expression:([A-Za-z0-9\s]+);​

For each match, search for {{x.group_1}}

------------------------------
Sean Connaughton
------------------------------

Forum|alt.badge.img+4
Hi Mike,

This is what I used to get started, it is a really useful skill to have!

Youtube Tutorial: https://www.youtube.com/watch?v=sa-TUpSx1JA
Cheat Sheet: https://cheatography.com/davechild/cheat-sheets/regular-expressions/
Mozilla Documentation: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Regular_Expressions/Cheatsheet

FYI, I think the last object in the text will not be found unless there is a semicolon after it. You could probably work it out with a "?" but I usually take the easy way out and just do the following in my text field.

Example:

Text: {{a.project_phases}};
Regex: ([A-Za-z0-9\s]+);

Notice the semicolon at the end of the Text will let the regex capture all objects.

------------------------------
Sean Connaughton
------------------------------