Is it possible to divide in Formatter using any available punctuation (eg . , : ; “ ‘ etc)? I’d like to be able to extract the physical address from an address string, and there are occasionally different dividers used.
Best answer
Formatter - Separate using any punctuation
- Beginner
Best answer by Danvers
Hi
If you have a paid Zapier account (ie not a Free account) then the AI by Zapier app might work here. AI by Zapier can parse text and break it into separate pieces using AI rather than a specific set of parameters. It’s a lot more powerful than the Formatter, but obviously we can’t guarantee that it will get exactly what you need every time. That said, it has definitely surprised me with how much it can do!
Here’s a help guide that explains how AI by Zapier works. Another caveat is that it is still in Beta, so it may be update or improved in the future.
If it does work for you, I’d love to hear how you got on. As it’s a new app, I haven’t heard from many users who use it and it’d be great to hear how you found the set up process, what you’re using it for and/or what else you think you could use it for :)
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Good question.
With Formatter > Text > Split, you can specify the separator:
- Beginner
I’m looking to use multiple separators, ie split the text on all the separators listed. It appears that ‘Split’ only allows for one separator at a time.
+14- Zapier Orchestrator & Solution Partner
In that case, you’d likely have to use a Code step.
The JavaScript .split() method supports regex.
Related help topic:
+12- Zapier Staff
- Answer
Hi
If you have a paid Zapier account (ie not a Free account) then the AI by Zapier app might work here. AI by Zapier can parse text and break it into separate pieces using AI rather than a specific set of parameters. It’s a lot more powerful than the Formatter, but obviously we can’t guarantee that it will get exactly what you need every time. That said, it has definitely surprised me with how much it can do!
Here’s a help guide that explains how AI by Zapier works. Another caveat is that it is still in Beta, so it may be update or improved in the future.
If it does work for you, I’d love to hear how you got on. As it’s a new app, I haven’t heard from many users who use it and it’d be great to hear how you found the set up process, what you’re using it for and/or what else you think you could use it for :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.