AnsweredAssumed Answered

Search String Not Recognized

Question asked by aklobby on Apr 1, 2014
Latest reply on Apr 1, 2014 by aklobby

Title

Search String Not Recognized

Post

     I am running a script that calls an If statement to determine if a search string exists in a field then set field in another field. This works great with some search strings but not all. The example of the working search string if statement is: 

      If[datafield = "GN2008"]

     Set Field [newfield; 1]

     End If

     The one that does not work is:

       If[datafield = "GN04"]

     Set Field [newfield; 1]

     End If

     Not sure why this will not recognize the shorter string. If I perform a find with that criteria filemaker finds those records, but the if statement and a substitute function do not recognize the string. 

     Any insight is most appreciated. 

     Allison

Outcomes