read text file with stange format

[John]

I have a text file that is formatted like this:

123456789 SOLD 1
12/12/2006 Smith 45,525
987654321 SOLD 3
01/01/2006 Jones 23,252
I need to read this file and parse the data and then load it into the
database. I can get the values for line one but how can I get the values for
the next line? I'm using the substring() method to get my data but when I
try and get the second line its returning me the data for the first line

[Göran Andersson]

It sounds like a simple mistake in the code, like reading from the wrong
string variable, or something.

What does the code look like?
John wrote:

I have a text file that is formatted like this:

123456789 SOLD 1
12/12/2006 Smith 45,525
987654321 SOLD 3
01/01/2006 Jones 23,252
I need to read this file and parse the data and then load it into the
database. I can get the values for line one but how can I get the values for
the next line? I'm using the substring() method to get my data but when I
try and get the second line its returning me the data for the first line

[John]

the code is just reading the file line by line and getting the string value
using string.substring() method
the code works with all of the other files it reads and uploads, I just have
a newly formatted file that needs to be read
"Göran Andersson" <gu***@guffa.com> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

It sounds like a simple mistake in the code, like reading from the wrong
string variable, or something.

What does the code look like?
John wrote:

I have a text file that is formatted like this:

123456789 SOLD 1
12/12/2006 Smith 45,525
987654321 SOLD 3
01/01/2006 Jones 23,252
I need to read this file and parse the data and then load it into the
database. I can get the values for line one but how can I get the values
for the next line? I'm using the substring() method to get my data but
when I try and get the second line its returning me the data for the
first line

[Göran Andersson]

The substring method can't return characters from any other string than
the one used to call the method.

John wrote:

the code is just reading the file line by line and getting the string value
using string.substring() method
the code works with all of the other files it reads and uploads, I just have
a newly formatted file that needs to be read
"Göran Andersson" <gu***@guffa.com> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

It sounds like a simple mistake in the code, like reading from the wrong
string variable, or something.

What does the code look like?
John wrote:

I have a text file that is formatted like this:

123456789 SOLD 1
12/12/2006 Smith 45,525
987654321 SOLD 3
01/01/2006 Jones 23,252
I need to read this file and parse the data and then load it into the
database. I can get the values for line one but how can I get the values
for the next line? I'm using the substring() method to get my data but
when I try and get the second line its returning me the data for the
first line