2 Replies Latest reply on Sep 11, 2012 2:07 PM by PaulWebb

    Extracting data to separate fields

    PaulWebb

      I have a 1 column excel file that I am importing and I need to extract a few pieces of data from the field.

       

      The data looks like...

      [ACYCLOVIR 200 MG CAPS][1.12][Take 1 cap 5 times daily for 7 days total for outbreak][35][3][][][0][53002024560][12405010000110][24418][22138][R][ACYCLOVIR][N]

       

      FM DB has the following fields.

      Import - what you see above

      Drug

      sig

      qty

      RF

       

      I need to extract the following into the matching fields.

      DRUGSIGQTYRF
      [ACYCLOVIR 200 MG CAPS][Take 1 cap 5 times daily for 7 days total for outbreak][35][3]




       

      I need some direction on what functions to look at to grab what I need. I have FM Pro Adv 11 & 12.

       

      Thanks