PaulWebb

Extracting data to separate fields

Discussion created by PaulWebb on Sep 11, 2012
Latest reply on Sep 11, 2012 by 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

Outcomes