Remove Byte Order Mark (BOM) special characters --  -- from the beginning of CSVs | Adobe Higher Education
Skip to main content
tim_wilson11
Level 2
January 20, 2014
New

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

  • January 20, 2014
  • 0 reacties
  • 1109 Bekeken

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.