topic Weird Characters added to first header when using Get CSV Text as Collection in Product Forum

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

SaraBardaji_Ser — Tue, 05 Apr 2022 11:00:53 GMT

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.

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

PabloSarabia — Tue, 05 Apr 2022 11:28:56 GMT

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 🙂

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

PvD_SE — Tue, 05 Apr 2022 11:45:18 GMT

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.