How to convert tabs to carrort character in a tab delimeted text file? 1

[vinidel]

Hi ALL,

I want convert a tabs in tab delimeted text file to carrort characters. Can anyone guide me how to do it using VB.NET code.

Thanks

 

[vinidel]

Sorry I misspelled Delimited as Delimeted.

 

[ThatRickGuy]

If you can read the text into a string you can use String.Replace(controlchars.tab, "^")

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[vinidel]

Thanks ThatRickyGuy for your guidance.

Here is the code if someone needs it:

Try
' Create an instance of StreamReader to read from a file.
Dim sr As StreamReader = New StreamReader("C:\XLS-TO-TEXT\USING-XLS-LIB\XLStoTEXT\bin\FINAL.txt")
Dim sw As StreamWriter = File.CreateText("C:\XLS-TO-TEXT\USING-XLS-LIB\XLStoTEXT\bin\FINAL1.txt")

Dim line As String
' Read and display the lines from the file until the end
' of the file is reached.
Do
line = String.Empty
line = sr.ReadLine()
line = line.Replace(ControlChars.Tab, "^")
line = line.Replace(ControlChars.Quote, "")
sw.WriteLine(line)
sw.Flush()
Loop Until line Is Nothing
sr.Close()
sw.Close()
Catch E As Exception
' Let the user know what went wrong.
Console.WriteLine("The file could not be read:")
Console.WriteLine(E.Message)
End Try