CSV contains carriage returns

[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.

[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!