Yesterday I learned how to use case to generate text in a different filed. That is working good!
Today I need to do something similar but with variable text.
I need it to have filed 1 find a phase such as (FS) and replace it with <b>(FS)</b> in field 2. Thing is, as in my example the text that comes after and before the text I want to change can be different in every record.
So anyone have an example of how I can change (FS) or (RS) and not change the surrounding text?
Sample of test in Filed1:
(FS) NAME (RS) NO X
What I would like ti to become: (Name and No are different in every record, the (FS) and (RS) can be one of 5 different () things)
<b>(FS)</b> NAME <b>(RS)</b> NO X
Any Ideas on how I can accomplish this and do you have a sample (New to the scripting stuff in FMP)