Hi,

I aim to do this in an Access 97 form as I dont have access to VB6.

Anyway, I would like some tips on how to extract info from a text file and write it to another.
I am aware of how to open,read and then write to a text file but I am unsure how I pick out the position of the info i want.

here we go...

I require to extract a ten digit number from a text file which occurs on the 5th line of every section and is five spaces in from the left margin.


example of text file:

customer 1
blah blah
blah blah
blah blah
blah:177690303 (this is the number i need)
blah blah
blah blah
blah blah
blah blah

customer 2
blah blah
blah blah
blah blah
blah:897690302 (this is the number i need)
blah blah
blah blah
blah blah
blah blah

customer 3
blah blah
blah blah
blah blah
blah:3857690334 (this is the number i need)
blah blah
blah blah
blah blah
blah blah

On the whole the positioning of the numbers stays static but if it didnt is there a way of searching for a cluster of ten numbers and extracting those?

Once extracted I then would like to save the info to another text file as tab delimited.

Any thoughts guys?