Remove Byte Order Mark (BOM) special characters --  -- from the beginning of CSVs

Avatar

Avatar
Boost 5
Level 3
tim_wilson11
Level 3

Likes

39 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
tim_wilson11
Level 3

Likes

39 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
tim_wilson11
Level 3

20-01-2014

For Data Warehouse .csv queries, the file has three pesky characters -- ï»¿ -- at the beginning of the file. At best, that's just a nuisance, but, at worse, it requires some cleanup scripting if that file is being pulled into another system via FTP.

 

From poking around online, this has to do with the encoding of the file. It would be great to never see those characters again.