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][R][ACYCLOVIR][N]
FM DB has the following fields.
Import - what you see above
I need to extract the following into the matching fields.
|[ACYCLOVIR 200 MG CAPS]||[Take 1 cap 5 times daily for 7 days total for outbreak]|||||
I need some direction on what functions to look at to grab what I need. I have FM Pro Adv 11 & 12.