Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Do we have any option to escape "escape characters" from Data File Loading??

vasudevaraog731
Level 3
Level 3

Hi,

Do We have any option to escape the escape characters(In my Example like backslash("\")) apart form single and double quotes from Data loading activity.

In one of our ingestion file contains escape character "\" loading in file to escape the pipe(|) character as mentioned in below screenshot ?

1298757_pastedImage_0.png

1298758_pastedImage_1.png

1 Accepted Solution
florentlb
Correct answer by
Level 10
Level 10

Hi,

I don't think this can be done directly in Campaign. Do you have a way to process the file before it is ingested in Campaign? In order to either remove unwanted characters or to add quotes for every column?

Florent

View solution in original post

2 Replies
florentlb
Correct answer by
Level 10
Level 10

Hi,

I don't think this can be done directly in Campaign. Do you have a way to process the file before it is ingested in Campaign? In order to either remove unwanted characters or to add quotes for every column?

Florent

View solution in original post

vasudevaraog731
Level 3
Level 3

Do you have a way to process the file before it is ingested in Campaign?

The file pushed from on of the Third Party system {EDW} to adobe campaign SFTP sever, after that we are picking the file using file collector.We don't have any control over the third party system pushing file to Campaign SFTP location.Just checking If there is any option in Campaign to avoid these characters.

Thanks for Confirmation!