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, u00B6This took care of most of the line breaks but there are still 2 stubborn li...
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
Hi Brent - loved this solutions unfortunately I am still getting stuck on 2 stubborn line breaksI need help - my CSV file is downloading the line breaks in my long text fields - I tried to eliminate them by running >REGEX_REPLACE for \r, \n, \r\n, u2...
You can try running REGEX_REPLACE({field},"\n"," ") or if its stubborn like in my case REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE({Field},"\r"," "),"\n"," "),"\r\n"," "),"u2028"," "),"u2029"," ")...
