Forum Discussion

kluo's avatar
kluo
Occasional Contributor
15 years ago

Strange Characters for the first column name in a CSV file

Hello, When I ran attached MyScript I alwasy encountered the following message 'Parameter name does not exist'; I double checked the .CSV file with NotePad and Excel, I did see the 1st c...
YMinaev's avatar
YMinaev
Icon for Staff rankStaff
15 years ago
Hi,



If you look at your file's contents in any editor which allows viewing text files in hex, you'll see 'Ï»¿' in its first bytes. The MS Jet engine reads them and passes them to TC when you access your file. This is because your file is saved in UTF-8.

Try opening it in Excel and saving as 'CSV (MS-DOS)'.