Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Coffee Break: Join us on Wednesday, April 5th at 10am PT to chat with Ben Gaines, Director of Product Management for Adobe Analytics. Ben will be online to answer your Analytics and Adobe Summit questions.

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

Avatar

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.