Find Values in Text File after user specified string

[jherget]

Hi Guys,

I'm having trouble finding the best way to extract data from a text file. Below is an example of the text:



09-27 +0.81
12-12 +0.56
02-16 +0.19
03-01 +0.02
LO
HI
L3213141 X 22 Y= 44 Z 66
Mean Range 6 Sigma Samples
+0.2 0.1 +11 19
I= 0.056 J 0.533 K 0.813 F FLUSHNESS

Basically the program I need to write has to ask the user to specify what point they are interested in (in this case L3213141). From there I need to extract the values for X,Y,Z and I,J,K and output to an excel worksheet. The position is not always the same in each text file for these values but they do always come somewhere after the name of the point (L3213141). Any help would be appreciated!

 

[Rijnsent]

Hi Jherget,
is that the complete text file or are there more lines to it? Looking for your six values, I see "I=", "Y=" and the other letters without an "=" behind them, is that formatting always the same? And are X,Y and Z always on the same line? And I,J and K? Basically, to write some decent code, it's practical to know whether the values are just randomly anywhere in your text or if there is some logic to it. And if you have some code, please do post it here (in [ CODE ] brackets).
Thanks,
Koen