• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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