Weird Characters added to first header when using Get CSV Text as Collection

[SaraBardaji_Ser]

Hi, I would really appreciate any help with this problem.

I am using the Get CSV Text as Collection action form the Utility - File Management VBO and when it reads the first header it adds some strange characters. For example: id the first ehader is ID, then the Collection has ID as its header.

Any way to avoid this from happening? Thank you in advance.

[PabloSarabia]

Hi @SaraBardaji_Ser

Probably, the problem is with the encoding of the file.​ (UTF-8, ASCII....)

Can you check wich encoding are you using?


See you in the community, bye 🙂

[PvD_SE]

With the risk of stating the obvious:
In addition to Pablo's likely correct answer I can add that Windows WordPad may not be the optimal tool of choice to check your file for funny characters. I'd recommend to use NotePad++ instead.