I'm trying to build a Zap that get's a response from an API from Booqable and creates a task in Asana.
I have the response as a value that it's something like this: "4x4 Carbon Fiber Matte Box, Subloc filtro x, subloc bbbb"
And I would like to pass to the next action only strings between commas that have "Subloc" in it (ignoring case). I've tried many things and got some regular expression: (?<=,)[^,]*((?i)Subloc[^,]*)(?=,)*. In every place it returns correctly, but on zapier I got outputs blanks.
I've also tried to "Line-item to text" or "pick from list" inside the format utilities without avail.
Is there a better way to get those two items between commas containing "Subloc" (or "subloc") and pass both (separately) to the next action (create task in asana).
Thank you very much
Best answer by GetUWiredView original