June 23, 2010 at 3:55 pm
I have a csv file that I want to open, find commas (,) and replace them with nothing (""), save and close.
This is what I have so far:
Public Sub Main()
Dim fn As String
Dim t As String
fn = "\\SQL2\Import\AccellerDailyDownload_TEST.csv"
t = System.IO.File.ReadAllText(fn)
While Not ((missing this piece))
t = t.Replace(",", "")
End While
End Sub
June 23, 2010 at 4:36 pm
you do not need to put the command in a while statement; .Replace will replace all instances of the comma in one single function call.
Lowell
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply