I am using a FileMaker Pro with a php plugin (http://www.scodigo.com/)
Sample Data (fixed length):
Acq On : 18 Feb 2007 22:39 Operator: FJN
Sample : Jones 1925 10 Inst : GC_MS
1) 5aAndrostan-3a,17a-diol 11.24 241 186712 2500.00 0.02
27) Stigmasterol 26.97 394 9158 2500.00 ng 0.02
30) Cholesteryl Butyrate 30.59 368 23219 2500.00 0.02
Goal:
I want to get the data following the labels: "Acq On:", "Operator;", etc.
Acq On: = 18 Feb 2007 22:39
Operator: = FJN
I would also like to grab the data following "1)","27)",30)", etc.
27) = Stigmasterol 26.97 394 9158 2500.00 ng 0.0
I also need to parse the data following "27)".
Possibly use a pattern count on any digit preceding a ")"?
Is there a way to get x number of characters following the pattern match?
Is there a way to get x number of characters following the pattern match to the end of line?
Thanks,
-Jeff