Forum Discussion
Syndicate_Admin
Administrator
AdministratorExport to CSV does not remove line breaks
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?
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
2 Replies
Syndicate_AdminThank you very much, you solved it!
Big hug- jdbuchanan71
Super User
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