Handle comma data in csv file in Azure Data Factory
|veera 1 post||
I have a csv which is somewhat like foo,bar. This must go into a single column but what I see is it goes into a separate column as it is comma delimited.
How do we handle this ? I also added double quotes “foo,bar” and put the escape character as double quotes(") in source but I get the data with the double quotes in the final data.
Please suggest how do we handle this situation in ADF ?
* For speed and versatility, Corrections.com has been relaunched in opensource. Some older postings dates may be affected.