Forum Discussion

rmsl's avatar
rmsl
Frequent Visitor
3 years ago

Weird behavior when importing data from cvs

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

Need Help

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    3 years ago

    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's avatar
      rmsl
      Frequent Visitor
      3 years ago

      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.