Pipeline workaround - 'is contained within'
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...
Forum Discussion
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
------------------------------
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
------------------------------
- Thanks for the info. I'm a bit confused though.
If what I want is a condition that says, Field A is contained within Field B (from another table)
In pipelines I can choose, Field A - match regex - xxxxxxxxxxxxxxx (type expression).
So If I type the Regex experssion you posted, how to I reference Field B? Where does the text expression go?
------------------------------
Mike Tamoush
------------------------------- I should have mentioned in one of my previous responses that you will need to use the text channel:
I just blocked out my Pipeline account details, but I hope that helps. You would just need to change the search query to whatever field you need to check on. E.g. query: Field A contains {{b.group_1}}
------------------------------
Sean Connaughton
------------------------------
