I am using Zapier to extract data from trello and store them in a google sheet spreadsheet. I mostly used regular expressions and it mostly works.
However, I tried to used the positive lookbehind in Formatter but it doesn’t seem to be working.
What I want is to get numbers after a specific character (:).
Here is my string :
3 dirigeants
Vendredi : 2, Jeudi : 3, Mercredi : 1, Mardi : 2
Here’s what I wrote :
(?<= :)\d+
Maybe I made a mistake but I can’t see it… by any chance can someone try to help be understand ?
Thank you very much !
Best answer by ForYourITBest answer by ForYourIT
Hi @Hana_ha ,
It looks like you might need a loop that iterates threw the matches and adds it to an array. In this case, I would advise you to talk to a Zapier expert or anyone else with this knowledge. Something like :
const matches = myString.matchAll(regex);
var matchExtracts = [];
for (const match of matches) {
matchExtracts.push(match);
...
}
would be needed. I don't want to direct you in any way, so feel free to try it out yourself ;) If you need any advise or assistance feel free to send me a message.
If your string always looks like the above, I think you have a small little error here. It looks like you are missing a space after the : sign. Should be like this:
Hi @Hana_ha I am not sure what kind of workflow you have.
You say you use Trello, but is this information all in 1 card in 1 line? What is the current result & what are your expectations? Having a screenshot of your setup makes it a lot easier as well.
It looks like you might need a loop that iterates threw the matches and adds it to an array. In this case, I would advise you to talk to a Zapier expert or anyone else with this knowledge. Something like :
const matches = myString.matchAll(regex);
var matchExtracts = [];
for (const match of matches) {
matchExtracts.push(match);
...
}
would be needed. I don't want to direct you in any way, so feel free to try it out yourself ;) If you need any advise or assistance feel free to send me a message.
I tried out maaany things and thanks to you, as you pointed me in the right direction, I finally have what I want.
I finally used the ‘Code by Zapier’ action as it was what worked best here and did a little thing in Python (after several tests and errors). But I will definitly try again with something like what you wrote so that I can know both ways to do it.
This is what I have now, if it can help someone someday…
Basically, I extracted all the numbers, converted them from str to int and add these numbers together to have the result in my spreadsheet.
