Remove Tab fields from Text File

[DesertDBA]

I want to remove the Tab fields from the Text File I am importing. The file is a ASCII text file, but when I use READLINE to get the data it is reading in the TAB code. How can I remove the Tab code from the import??

Example of the Text File :
A_MASTERID 546
A_FNAME Fred
A_MI
A_LNAME Milner
...

- Jason Milner

 

[chrissie1]

TextBox2.Text = TextBox1.Text.Replace(" ", "tab")

the first " " is actually just a tab I typed.


Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[ThatRickGuy]

Or:

strLine = StreamReader.Readline().Replace(controlchars.Tab, "")

-Rick

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

 

[chrissie1]

I tried the controlchars.tab and it didn't seem to work.

Desertdba will tell us wich one did.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[ThatRickGuy]

I guess it would matter on the way the tab char was stored. Some apps store Tab as individual spaces as opposed to a single tab character.

-Rick

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

 

[tyreejp]

You *could* use regular expressions as well...

Dim ResultString As String
Try
ResultString = Regex.Replace(SubjectString, "[\t]", "")
Catch ex As ArgumentException
'Syntax error in the regular expression
End Try

--
James

http://www.microsoftjr.com