Do we have any option to escape "escape characters" from Data File Loading?? | Community
Skip to main content
V
vasudevaraog731
Level 3
September 14, 2017
Solved

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

  • September 14, 2017
  • 2 replies
  • 2523 views

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 ?

    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 florentlb

    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

    2 replies

    florentlb
    florentlbAccepted solution
    Level 10
    October 9, 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

      V
      vasudevaraog731Author
      Level 3
      October 9, 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!

      Terms & ConditionsAccessibility statement

      Loading footer...