I have this csv file which I’m not able to delimit correctly using Read CSV activity. When I read the CSV only the top row (column names) are delimited, while all other rows are not. The correct delimiter is comma, and this is also used in Read CSV activity.
I have tried to delimit the file in Excel Power Query with the same results. However if I use the text to columns function in Excel the data delimits correctly.
I have attached a dummy workflow with a selection of the data.
Any help would be appreciated.
csvTest.zip (19.6 KB)