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

Avatar

Avatar
Validate 1
Level 2
vasudevaraog731
Level 2

Likes

6 likes

Total Posts

51 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 1
Give Back 5
View profile

Avatar
Validate 1
Level 2
vasudevaraog731
Level 2

Likes

6 likes

Total Posts

51 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 1
Give Back 5
View profile
vasudevaraog731
Level 2

14-09-2017

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

09-10-2017

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

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 2
vasudevaraog731
Level 2

Likes

6 likes

Total Posts

51 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 1
Give Back 5
View profile

Avatar
Validate 1
Level 2
vasudevaraog731
Level 2

Likes

6 likes

Total Posts

51 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 1
Give Back 5
View profile
vasudevaraog731
Level 2

09-10-2017

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!