• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

How to use the text formatter module to replace multiple values with blank?

I'm only aware that the module can only find and replace one string at a time. Would it be possible to replace apostrophes, commas, forward slash, or periods with blanks using only one module instead of four?
 

Fagun Shah

Well-known member
Actually it should be possible using SUBSTITUTE formula in Number Formatter -> Spreadsheet Formula. But it is buggy in pabbly connect. They need to make it proper. here is the example in gsheet which works proper.

1645241590378.png


And here are results in Pabbly Connect's New and Old Number formatter(both are not working properly) -

1645241719492.png
 
Top