Author: j_energy | Posted on: 6/2/2009 8:54:35 AM | Views : 668

I have a very simple form which when submitted writes to a text file.
To create a file that cab be opened as a tab delimited file in Excel I am adding tabs between each input filed something similar to this:
objStreamWriter.WriteLine(txtEmail & " " txtMessage & " " & DateTime.Now.ToString())

Everything is writing to the file as it should.  However since txtMessage is a text box, their is to potential to enter a Tab if a user where to copy and paste input from another applicaiton and even more likely they can enter carriage returns.
 When I test with either Tabs or Carriage returns and then open the file in Excel my columns get all out of synch.  I understand that I need to parse the string (I am guessing that i need ot replace tabs or carriage returns) and modify it before it gets written to the text tile.  I am not sure if there are characters that can be used to replace the ori ...

Go to the complete details ...