The following replaces the Tab but even though the CSV file open in Excel and shows both the equal sign and the two quotes (created by Chr(34)) when there's a comma (,) in the text it still pushed it into a new row?!
It's generated from VB.Net/SQL into a CSV file.
vDataRowOkay = IIf(datarow("RandomText").Equals(DBNull.Value), "", datarow("RandomText").ToString)
vDataRowOkay = Replace(vDataRowOkay, vbTab, " ")
str.Append("=" & Chr(34) & vDataRowOkay & Chr(34) & ",")
Comes out as:
="random content, other bits of text"
But in Excel is shows as
Cell 1: ="random content
Cell 2: other bits of text"
I am not quite sure what's wrong.
text at end written to CSV via:
My.Computer.FileSystem.WriteAllText(("C:\Sites\Reports\test.csv&q ...
Go to the complete details ...