I am writing to a .csv file using .WriteLine(sometext) and find that the first row appears to have hidden characters prefixed to it.
When inspecting the .csv in Excel or by notepad the first letter T is ok, however I believe there are hidden characters before the T. Inspecting the file with a HEX reader there is definitely some unprintable characters at that position.
This is the first line of the file.
The actual text is "T,9999999, ,Company Name,X,D," +
Strings.Left(strDateEnded, 2) + Strings.Mid(strDateEnded, 4, 2).PadLeft(2, "0"c) + Strings.Right(strDateEnded, 2) + "," +
Strings.Mid(strDateStarted, 4, 2).PadLeft(2, "0"c) & Strings.Right(strDateStarted, 2) & ",xxx01, ,"