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!
Solved
CSV Downloading unwanted line breaks in long text
+4Best answer by Lulenka
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😜
+4I 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😜
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.