AnsweredAssumed Answered

Parsing text or number characters outside a search string

Question asked by livermd on Feb 4, 2010
Latest reply on Feb 8, 2010 by livermd

Title

Parsing text or number characters outside a search string

Post

I'm trying to extract values from lab entries for a database to keep tract of patient data.  For example, I have a data field named "Import".  I can copy data from our lab computer as shown below.  I also have a data field named "creatinine".  

 

GLUCOSE RANDOM: 80

CREATININE: 0.6 (L)

POTASSIUM: 4.0

CO2: 25 

 

I want to extract only the numeric value to the right of the set of characters "CREATININE" without the "(L)"

 

Is this possible? 

Outcomes