Weird behavior when importing data from cvs

[rmsl]

Hi all,

I am importing some data from a csv file but some columns are showing and being recognised as empty for some reason. Then any manipulation would result in an error afterwards;

here are the screenshots;

then when trying for example to put first line as title;

Any Ideas?

Thanks,

Rmsl

[HotChilli]

It looks like there are spaces or tabs or hidden characters in the csv file.

If this is a one-off, you can just delete the extra columns, job done.

If this happens consistently , there are other techniques e.g. you can pass the number of columns to csv.Document as a parameter and it will ignore any 'extra' ones

OR add a 'remove other columns' step once you have selected all the desired columns.

[rmsl]

@HotChilli thanks - however I've tried to locate spaces / tabs or hidden characters and nothing. Those blank columns aren't extra columns - they are somehow being considered as blank whereas they aren't.

When trying to filter the column 13 which as you can see shows "WM" many times - the only option is (Blanks)

Also, when openning the reports via folder (i.e. Csv.Document(File.Contents( etc.) it works fine.