Data feild comma data impact to csv file creation issue

Question

Hi Team,

Currently i have setup a copy activity for a SQL query output .csv file create on the Data Lake destination, But in the one table address level details there have a comma (,) on the inside of the data fields, Due to the that reason, created .csv file data has been spitted as a abnormally and incorrectly, How can i sort out this issue? Could you please advise on this for your reference below have attached sample issue snap.

Answer 1

Hello @Mahesh Madhusanka and thank you for your question.

One solution would be adjusting your csv creation so it quotes the problematic field. Quoting a field helps recognize that any commas inside the quotes are part of the value, and not for separating the cells. Your values already have "quotes" in them, so a different character/symbol should be used. In the delimited text dataset you can specify what you use for the quote character. Whichever character you choose, it should not be found in any of your values.

My personal favorite, is the control character "bell" .

----------

Thank you

Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.