Reading CSV with semicolon as separator

Help Studio
, ,
1

Hi,

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?CSVFile.zip (13.2 KB)

2

can you share the csv

1 Like
3

Hi @ImPratham45CSVFile.zip (13.2 KB)

Just attached the workflow

4

Hi @alpharobot,

Use the following one

When reading CSV file it will add double Quotations because it having Semi colons

CSVFile.zip (19.9 KB)

1 Like