• 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.

Line break in Google Sheets

mbdrs

Member
I need to remove line breaks but it does not appear to be working. Here are the settings - as you can see the line breaks are not removed in Google Sheets (from Wordpress, Contact form7 form). I also tried <br> instead of \n

2025-02-26 10_37_55-Media Player.png



2025-02-26 10_31_46-Tilbud_drift - Google Sheets.png
 
Last edited:

Preeti Paryani

Well-known member
Staff member
Hello @mbdrs,

Please try replacing \r\n with blank and let us know if it works fine for you, refer to the attached image for more info.

1740585523151.png
 

mbdrs

Member
Thanks, but I already tried and it's still the same issue. I know it's possible because it worked with WPautomator.
 

Preeti Paryani

Well-known member
Staff member
Hello @mbdrs,

The suggested workaround should work as we have tested it with the text received from the webhook, and it functioned as expected. Please try implementing it on your end, and if it does not work, kindly provide us with the Task History ID so we can analyze the issue further and offer the appropriate solution.
 

mbdrs

Member
I tested again now and now it does appear to have made a difference, see screenhot- Top row in screenshot is before and bottom row is after. B
2025-02-28 13_18_46-Tilbud_drift - Google Sheets.png
ut I need the final result to appear on a single line instead of stacking them.
 

Preeti Paryani

Well-known member
Staff member
Hello @mbdrs,

Please try adding an additional \r after \n in the find field and check if it works as expected. Let us know if you need further assistance.
 
Top