8 Replies Latest reply on Feb 8, 2010 7:51 PM by livermd

    Parsing text or number characters outside a search string

    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?