Why some CSV files have these weird characters  in the first line column

Just wondering. Some CSV files have it, some don’t. Should that be removed? Does it batter if it is there? I use MacOS, is this related to Windows?

It may be a BOM (byte order mark) used to give a hint that the file has Unicode text encoding:

Generally Easy Data Transform will handle BOMs without you knowing about it.

If you don’t want to output a BOM then uncheck Byte Order Mark when you are writing to a file.

Does that help?

2 Likes