Open a csv file do Find and Replace then Save

• smacumber 77733

  Ten Centuries

  Points: 1288

  More actions

  June 24, 2010 at 7:09 am

  #387213

  I have a csv file that I want to open, find commas (,) and replace them with nothing (""), save and close.

  Posted this in the wrong forum.

  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)

  t = t.Replace(",", "")

  End Sub

  I changed a bit due to a previous comment. I run this, says it succeeded but I go and open the file and the commas are still there, what am I missing?

  Thanks!

• Ed Zann

  SSCrazy Eights

  Points: 8694

  More actions

  June 24, 2010 at 7:23 am

  #1184478

  You have to write the file back to disk. Add this:

  System.IO.File.WriteAllText(fn, t)