Reading CSV with semicolon as separator


Trying to read CSV which has semicolon as separator.

Selected the semicolon as separator in the “Read CSV” activity but only headers are getting separated. The row values are all coming in the first column as unseparated value.

Attach is the sample workflow, can anyone help me in knowing the mistake and how to correct this? (13.2 KB)

can you share the csv

1 Like

Hi (13.2 KB)

Just attached the workflow

Hi @alpharobot,

Use the following one

When reading CSV file it will add double Quotations because it having Semi colons (19.9 KB)

1 Like