CSV comma issue in Sink

Gowri Shankar 226 Reputation points
2020-12-11T12:17:45.007+00:00

Hi,
My source file is having a column value like Naperville, IL
Please note that the value Naperville, IL is a single column value.
I want this value to be written in a csv file.
When I try to write this data in csv (sink), the column value is getting separated like Naperville\, IL
and single column becomes as two columns (one col value as Naperville\ another one has IL).
Can you please let me know how I can handle this comma issue?
Please find the attachment for the sink setting.

Thanks.47404-sink.jpg

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,489 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nasreen Akter 10,736 Reputation points
    2020-12-12T04:01:24.553+00:00

    Hi @Gowri Shankar ,

    There is an option "Quote character" for the DelimitedText DataSet. Probably you have "no quote character" selected there. If that's the case, please change the option and it will work (see the screenshot below).

    Please let me know if this helps. If it does, please don't forget to "accept the answer" and "up-vote"! Thank you!

    47438-csvfile.jpg

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful