Level 2

Solved

Remove or replace carriage return line feed from failureMSG

3 replies
1174 views
Translate All

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.

SatheeskannaKAccepted solution

Adobe Champion, Community Advisor, UG Leader

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

Thanks, Sathees

Adobe Champion, Community Advisor, UG Leader

Accepted solution

Adobe Champion, Community Advisor, UG Leader

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

Translate

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")

Translate

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?

Translate