I am attempting to use Code by Zapier, Python, to extract a specific set of numbers in sequence from a random string of text. The set of numbers will start with four leading zeros. The Python code I am using is adapted from the following which I created in a Python compiler;
str = "body of SMS 5PM 9PM 2AM 4 8 2 00001124"
#search using regex
x = re.findall('0000+[0-9]+[0-9]',str)
The output from the above is 00001124, which is perfect.
In Code by Zapier Set up Action, I have the following:
The error I am receiving is this:
The objective is to search the entire string and only output the eight digits with four leading zeros. Thanks in advance.
Best answer by Troy TessaloneView original
Try using the Formatter > Text > Extract Pattern instead: https://zapier.com/help/create/format/find-text-with-regular-expressions-in-zaps
Output using the settings show below in the screenshots.
Try these settings
If using a Python Code step, the code would look like this:
…. A million thanks for your response, and explanation of the various methods to use. Also, it’s a pleasure interacting with you again!