Remove '+' '-' and blank spaces in data
Status: Closed · Asked by David Ho on · 0 views
How can I set up Pabbly to remove '+' '-' and blank spaces in the phone number, emails and other texts captured by webhook? What is the function/module I need to use? Kindly provide specific steps with screen shots.
How can I set up Pabbly to remove '+' '-' and blank spaces in the phone number, emails and other texts captured by webhook? What is the function/module I need to use? Kindly provide specific steps with screen shots.
Use text formatter by pabbly connect. Refer below screenshot for reference. Do same for Space in find instead of + use {{space}} and it'll remove space. Note: you can use number formatter as well.
FYI I'm not from Pabbly Connect team, just a freelancer who helps other Pabbly users.
What do I type in the field to remove a string of texts from 2 fields?
I have this from webhook:
"Date: 6 Oct 2025".
"+110000-1234".
I want to remove '+' '-' 'Date: ' and 'blank space' from both of the fields. Can I do it in a single find field?
What do I type in the field to remove a string of texts from 2 fields?I have this from webhook:
"Date: 6 Oct 2025".
"+110000-1234".
I want to remove '+' '-' 'Date: ' and 'blank space' from both of the fields. Can I do it in a single find field?
Write Regex. Ask chat gpt to write Regex for you to remove above things and in Text Formatter use Extract Pattern Action.
Write Regex. Ask chat gpt to write Regex for you to remove above things and in Text Formatter use Extract Pattern Action.
Thank you very much Himesh and I appreciate it!
You can also do this using Text Formatter (Pabbly) → Replace Text, like Himesh mentioned. Just run two replacements in sequence:
- Replace + with empty (leave replace field blank)
- Replace space " " with empty (or use {{space}} depending on your field)
That should clean phone numbers and emails coming from webhooks.
Also, small tip; if you’re dealing with user-submitted data (like forms or app inputs), it’s a good idea to standardize formatting before storing it. I ran into this when collecting user data for a small streaming app project (Sportzfy TV Streaming), and doing this cleanup step in Pabbly made everything much easier to manage later.
Hope that helps ?