Parsing text or number characters outside a search string
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)
I want to extract only the numeric value to the right of the set of characters "CREATININE" without the "(L)"
Is this possible?