Help

CSV Downloading unwanted line breaks in long text

Topic Labels: Importing & Exporting
Solved
Jump to Solution
420 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😜