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.
Contact me - https://www.facebook.com/himeshsoni07
Email - [EMAIL][email hidden][/EMAIL]
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 fieldsI 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.
Contact me - https://www.facebook.com/himeshsoni07
Email - [EMAIL][email hidden][/EMAIL]
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 ?