6 Replies Latest reply: Sep 2, 2014 5:09 AM by Stuart Frew RSS

    Expression will not work script side

    Stuart Frew

      Hi,

       

      I have an expression that works fine in a table box or chart and i want to use this script side.

       

      The reason I need it script side is I want to create a new field with a flag in it.

       

      if(max(len(keepchar(lower([Telephone Number]), '- ! # $ % ( ) , * . : ; ? @ [ ] { } | ~ < > = £ / \ & "'))) > 0, 1, 0)

       

      Basically the expression checks the telephone number field to see if there are any characters in there that should not be.

       

      Any thoughts are appreciated !

       

      Thanks

      Stuart