Forum Discussion
Weird behavior when importing data from cvs
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.
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.