Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

CSV Downloading unwanted line breaks in long text

Topic Labels: Importing & Exporting
Solved
Jump to Solution
777 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Lulenka
5 - Automation Enthusiast
5 - Automation Enthusiast

I need help - my CSV file is downloading the line breaks in my long text fields - I tried to eliminate them running >REGEX_REPLACE for \r, \n, \r\n, u2028, u2029, u0085, u00B6
This took care of most of the line breaks but there are still 2 stubborn line breaks I cannot beat HELP!

1 Solution

Accepted Solutions
Lulenka
5 - Automation Enthusiast
5 - Automation Enthusiast

I managed to figure it out!!! - my formula was spot on but I only focused on the long text fields - I did not realise that the short text fields could also contain line breaks??? go figure😜

See Solution in Thread

1 Reply 1
Lulenka
5 - Automation Enthusiast
5 - Automation Enthusiast

I managed to figure it out!!! - my formula was spot on but I only focused on the long text fields - I did not realise that the short text fields could also contain line breaks??? go figure😜