Remove or replace carriage return line feed from failureMSG

[LaraVl]

Hi,

I am exporting failed deliveries so we can clean our database. When I export the field 'failureMsg' (from targeting dimension) this containes carriage return line feeds that create unwanted new lines in my file. Is there a way to replace them for spaces?

[SatheeskannaK · Accepted solution]

@LaraVl, Try to apply string functions on the extract file activity to address the problem. 

[Hankins0202]

We have had the same expression for this and it seemed to work now it is throwing new lines.

Replace(@failureMsg, "\n", "\s")

[abduljab]

We are having the same issue. Were you able to figure out how we can avoid the new lines and also eliminate carriage return?