When I extract mobiles from the array, for some reason one is extracted without the last digit... how to solve it?
Best answer by Danvers
View original
When I extract mobiles from the array, for some reason one is extracted without the last digit
Userlevel 1
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+12
- Zapier Staff
- 3731 replies
-
3 November 2022
- Answer
Hi
I’m not too sure why the extract phone number is having difficulty with that phone number, but I can suggest an alternative.
Instead of using the extract phone number, use the extract pattern transform. Then use the following regex expression:
(?<!\d)\d{8}(?!\d)
And swap out the {8} with the number of digits in the phone numbers. If you want to give that a try, it’s worth testing it on a few different phone numbers to make sure that it works correctly.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.