reading values in from a text file

Hi Guys,

I have a text files that contains various information I need to feed into excel, I have tried importing data but the values in the text file are not organized well enough.

I would like to be able to search for a string like "field" and then store the the values on the same line immediately after it into excel. cells.


PD1 * * Client and Well Information 03-MAY-2011 16:27
PDB mode LIS USA
Company XXX
Well XXXX XX
Field WILDCAT
Prvnc/co XXX
Cntry/st XX XXX
Location XX XX XX
Unique well Id.
API Number XX XX API Number
Location 2 SW SW NW NE
Lsd Sec Twp Rge XX XX
Permit number Permit Number
Permanent Datum G.L.
Elevation XXX feet
Log Measured from K.B. @ 7 FEET
Elevation above PD feet
Elevn. of log zero feet
Drill measured from K.B.
Elevations: KB XXX F feet
DF XXX F feet
GL XXX F feet

Thanks for the help, I've attached the file.

I'm hoping that I do not need to post a sample excel file...once I know how to extract one value from the text files I'm hoping I can get the rest. Once the values are extracted and placed in individual cells I will be able to process them further. Some examples would be well name, company name, location, etc.

Originally Posted by thegoat001

I'm hoping that I do not need to post a sample excel file...once I know how to extract one value from the text files I'm hoping I can get the rest. Once the values are extracted and placed in individual cells I will be able to process them further. Some examples would be well name, company name, location, etc.

try this

Please Login or Register  to view this content.