InStr Function? - Please Help ASAP

[strom99]

I have the following 3 formulas to break up a description field and superscript the TM symbol. How do account for fields that don't have a "(TM)" symbol, the formula returns an error if it is not there?

Thanks

Formula 1:
left({string},instr({@string},"(TM)&quot-1)

Formula 2:
mid({string},instr({@string},"(TM)&quot,5)

Formula 3:
mid({string},instr({@string},"(TM)&quot+4)

 

[Thadeus]

You need a simple IF-THEN statement asking IF InStr({MyString},"TM&quot returns 0 THEN MyString

InStr returns a positional based integer. If str2 is not found in str1, the InStr function returns 0

 

[strom99]

Can you please help a little further, I am not getting this work, it looks like i need an instr function for each of the 3 formulas

 

[mbarron]

In the beginning of each formula use:

If instr({@string},"(TM)&quot>0 then
original formula
Else
Whatever you want if the (TM) isn't presentd Mike