Strange Characters for the first column name in a CSV file

Hi Kevin,



The code like below might help...

[convertToASCII.js]

var fileName = "C:\\Tests\\MyTest\\MyTestProject\\Script\\myScript.sj";



if (isUnicode(fileName))

{

  var fso = new ActiveXObject("Scripting.FileSystemObject");

  var aFile = fso.OpenTextFile(fileName, 1, false, -1);

  var text = aFile.ReadAll();

  aFile.Close();

  aFile = fso.CreateTextFile(fileName, true, false);

  aFile.Write(text);

  aFile.Close();

}

//-----------------------------------------------------------------------------



function isUnicode(fileName)

{

  var fso = new ActiveXObject("Scripting.FileSystemObject");

  var aFile = fso.OpenTextFile(fileName, 1, false, 0);

  var flag = aFile.Read(2)

  aFile.Close();

  var template = String.fromCharCode(1103, 1102);

  if (flag == template) return true;

  return false;

}

//-----------------------------------------------------------------------------