Q:
How to output a text file and separate the data into different fields using VB 2005
Visual Basic, VB, VB 2005, Visual Basic 2005, String manipulation, Comma-delimited, Text manipulation i am new at this.
This is an example of the data (in notepad) it looks like this..
1,ABC,12/12/2008
2,DEF,13/12/2008
3,GHI,14/12/2008
4,JKL,15/12/2008
i would like to read only the first line and have each field dim as varchar.
The output should be in this form:
Field 1 = 1
Field 2 = ABC
Field 3 = 12/12/2008
Thanks for your help. It's much appreciated..
This is an example of the data (in notepad) it looks like this..
1,ABC,12/12/2008
2,DEF,13/12/2008
3,GHI,14/12/2008
4,JKL,15/12/2008
i would like to read only the first line and have each field dim as varchar.
The output should be in this form:
Field 1 = 1
Field 2 = ABC
Field 3 = 12/12/2008
Thanks for your help. It's much appreciated..
ASKED:
Dec 11 2008 9:33 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
'Here's how you'd get the first line
Dim FirstLine as String
Dim oFile as System.IO.File
Dim oRead as System.IO.StreamReader
oRead = oFile.OpenText("C:\MyFile.txt")
FirstLine = oRead.ReadLine()
oRead.Close()
I don't have much time right now. Check out this article for the rest.
- Max
