Remove or replace carriage return line feed from failureMSG | Community

Level 2

Solved

Remove or replace carriage return line feed from failureMSG

Forum|Forum|2 years ago
November 13, 2023
1 reply
1147 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.

Community Advisor

Accepted solution

Community Advisor

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

Thanks, Sathees

Level 2

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

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

Adobe 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?