locked
Double Double quote in CVS file RRS feed

  • Question

  • Hi there 

    I am trying to copy data from a CSV file where some of the rows are in format "Super, ""luxurious"" truck"  which should all go into one column, however, ADF reads it as it belongs to two columns. 

    I have specified in the quote char as  ", however it is not working as intended. 

    Ideally I would want to avoid editing anything in the CSV file. Is there any way to get around this in ADF?

    Thanks



    Friday, May 3, 2019 1:43 PM

All replies

  • Hi there,

    what column delimiter did you set? I create a file with content: "Super, ""luxurious"" truck", set column delimiter as , (comma)  and quote char as " (double quote), click preview, it returned only one column. Would you please provide a piece of complete sample data you were using? 

    Monday, May 6, 2019 3:37 AM