Export to CSV does not remove line breaks

[Syndicate_Admin]

Good afternoon, everyone,

I have in my sales table a column called "Description". In this column users place some observation about the sale. The issue is that they make line breaks. To visualize these observations in a table I need to remove those line breaks and for this I use the function:

Detalle = SUBSTITUTE('facturas todas'[Descripcion],UNICHAR(10),"- ")

My problem is that when I export it to .csv these line breaks are still respected and do not appear already concatenated between two commas. As if the function did not move to export.

How can I do so that the whole description appears between 2 commas in the export and does not make line breaks?

[Syndicate_Admin]

Thank you very much, you solved it!

Big hug

[jdbuchanan71 · Accepted solution]

There might be both carriage returns and line feeds in the column.  Does this fix it?

Detalle = SUBSTITUTE(SUBSTITUTE('facturas todas'[Descripcion],UNICHAR(10),"- "),UNICHAR(13),"- ")

UNICHAR(13) is carriage return