Extract data from file

[themanof83]

Hello all,

I am trying to extract some data from a file so I can import it into a date field. The data lies on the third row of the file does anybody know how to grab it??? The data is as follows:

Test: 1a
Time: 14.02 pm
Date: 3-Mar-08

Your comments will be greatly appreciated.

Regards,

Ashley

 

[RuralGuy]

Hi Ashley,
Is it just a Text file?

 

[themanof83]

The file itself only contains text but has a company specific extension i.e. not .txt.

 

[RuralGuy]

If you post just the first 4 rows of the file as a txt file I'll bet someone here can come up with some code for you.