what are the list of special characters that should not be added in CSV file | Community
Skip to main content
G
gowthamr123
Level 2
February 6, 2024
Solved

what are the list of special characters that should not be added in CSV file

  • February 6, 2024
  • 4 replies
  • 2669 views

Hi All

 

In AEP i am trying to ingest the CSV file from SFTP and i am getting corrupt data error PFB screenshot 

 

Using Error diagnostics preview   i have find out the exact issue and resolved it.

 

Here i need to know  is there any list of special characters that need to considered and removed  while uploading the file .

 

Please any one help me with this.

 

Thanks in advance.

    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 ssj

    Hi Gowthamr123

     

    For csv, in general you need to avoid the character which you are using as delimiter, and the single row should not be split into multiple rows, meaning there should not be any enter character in between the data of a single record.

     

    --ssj

    4 replies

    Tof_Jossic
    Adobe Employee
    Tof_JossicAdobe Employee
    Adobe Employee
    February 6, 2024

    @gowthamr123 I realise I'm not answering your question but in case that helps, I found this data prep documentation:

    'Escape special characters'
    See https://experienceleague.adobe.com/docs/experience-platform/data-prep/home.html?lang=en#escape-special-characters
     

      NimashaJain
      Adobe Employee
      NimashaJainAdobe Employee
      Adobe Employee
      February 12, 2024

      @gowthamr123 Did you find the suggested solutions helpful? It would be great if you can  mark the answer as correct for posterity. If you have found out solution yourself, share it with wider audience in the community.

      G
      gowthamr123Author
      Level 2
      February 12, 2024

      Hi Nimashajain

       

      it is not relevant to my query ,Can you pls help me with any other resolution.

       

      Thanks in advance

      NimashaJain
      Adobe Employee
      NimashaJainAdobe Employee
      Adobe Employee
      February 12, 2024

      Did you find the suggested solutions helpful? It would be great if you can  mark the answer as correct for posterity. If you have found out solution yourself, share it with wider audience in the community.

      S
      Adobe Employee
      ssjAdobe EmployeeAccepted solution
      Adobe Employee
      February 16, 2024

      Hi Gowthamr123

       

      For csv, in general you need to avoid the character which you are using as delimiter, and the single row should not be split into multiple rows, meaning there should not be any enter character in between the data of a single record.

       

      --ssj

        Terms & ConditionsAccessibility statement

        Loading footer...