4 Replies Latest reply on Aug 5, 2014 11:36 AM by CarlaS

    Data validation for quotation marks.

    CarlaS

      Title

      Data validation for quotation marks.

      Post

           I am trying to create a data validation field that alerts users if they have entered a quotation mark into a text field.  I have been trying to play with the Evaluate and Quote functions but cannot come up with the answer. 

           If the field contains a quotation mark, I would like for the validation field to contain "The Item Description field contains a quotation mark.  This is an invalid character."

           I am using FM13 advanced.