Page 1 of 1

CSV contains carriage returns

Posted: Tue Feb 08, 2022 3:19 pm
by matthew.hearne
We have incoming data (a CSV) and some of the fields contain carriage returns. If we turn this CSV into XML, it's creating a lot more XML files that there are lines in the CSV due to all the carriage returns.

How can we remove the carriage returns in the CSV before converting to XML?

Thanks.

Re: CSV contains carriage returns

Posted: Tue Feb 08, 2022 6:03 pm
by freddyp
It will work with this app https://www.enfocus.com/en/appstore/pro ... ng-replace

In the "Strings" property write "\n= ". It is without the quotes and note the space!