Problem with Import a CSV File

Rene Fürstenberg 0 Reputation points
2023-12-06T07:53:54.73+00:00

Hello Community,

I have the following problem with an import of a CSV file.

This is an example for mein CSV File.

Microsoft Q&A 1

And these are my settings in the storage account.

Storag Account Settings

I now have the following problem.

The comma is the separator and I can't replace it beforehand. However, when I look at the preview, row 2 slips to the right and the correct values are not in the correct column.

I have marked this with an arrow.

What can I do to import this correctly?

Best regards

and many thanks in advance.

spaceman127

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,151 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Suba Balaji 11,206 Reputation points
    2023-12-06T12:55:06.3866667+00:00

    Hi,

    Unless your data comes with a quote character or escape character, it is not possible to read the given data correctly.

    So options are given below.

    1. Either put the values in double quotes
    2. Or put an escape character \ before comma between name6 and name7
    3. Or change the delimiter to tab or semi colon other than comma

    If it's not possible to make these changes in source side, you will have to write your own logic in azure function or batch, to process row by row and split it by checking the presence of {} using c# or python.

    Thanks.

    1 person found this answer helpful.