Skip to Content
0
Oct 30, 2013 at 11:49 PM

Formula to Determine Text Contents

28 Views

I would like to determine if a field contains a certain text string and if it does enter a "Y" in the field else "" (two pair of double quotes or blank/null).

I'm hoping that the following is close, but I know I'm missing something. Please help me edit this formula or suggest another method.

if {InStrRev ({Player.FirstName},"REFUSE" ,1 ,1 )} then "Y" else "" //Generates error "The field name is not known"

if InStrRev ({Player.FirstName},"REFUSE" ,1 ,1 ) then "Y" else "" //Generates error "A boolean is required here"