Remove or replace carriage return line feed from failureMSG | Community

New Participant

Solved

Remove or replace carriage return line feed from failureMSG

Forum|Forum|2 years ago
November 13, 2023
1 reply
1145 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by SatheeskannaK

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

SatheeskannaKAccepted solution

New Participant

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

Thanks, Sathees

New Participant

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

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

Employee

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