locked
Handle Quotes and Comma in CSV file using Mapping Data Flow RRS feed

  • Question

  • Hi All,

    I am trying to load one csv file using Mapping Data Flow activity in Azure Data Factory. But i couldn't handle some string column with text having comma and quotes in the text values. Column is getting drifted due to comma values with in the text. Please find below the screenshot of input and output of files i am trying to load using Mapping Data Flow.

    Input 

    

    Input from notepad

    Output

    I tried the escape character as " and backslash in both cases it is not working as expected.

    Thanks,

    Sathish


    Monday, March 23, 2020 5:56 AM

Answers

  • Hi Team,

    I got the solution now. To handle comma  and quotes in single text in  csv file, we need to use escape character as " in both source and sink activity.

    I tested and it is working fine now.

    Thanks,
    Sathish

    Monday, March 23, 2020 8:25 AM

All replies

  • Hi Team,

    I got the solution now. To handle comma  and quotes in single text in  csv file, we need to use escape character as " in both source and sink activity.

    I tested and it is working fine now.

    Thanks,
    Sathish

    Monday, March 23, 2020 8:25 AM
  • Hi Sathish,

    Glad to hear that your problem was resolved. Thanks for sharing your findings with the community.

    Monday, March 23, 2020 8:28 AM