Best answer

Troubleshoot error in Python code step to Extract Data From Random String

  • 26 May 2021
  • 4 replies

Userlevel 1


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)
print('%.8s' %x[0])


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 Tessalone 26 May 2021, 23:09

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 1


…. A million thanks for your response, and explanation of the various methods to use. Also, it’s a pleasure interacting with you again!



Userlevel 7
Badge +14


If using a Python Code step, the code would look like this:




Userlevel 7
Badge +14


If you use JavaScript Code step, the code would look like this:




Userlevel 7
Badge +14

Hi @Ty. 

Try using the Formatter > Text > Extract Pattern instead:


Output using the settings show below in the screenshots.


Try these settings