Skip to Content
avatar image
Former Member

Validation on double quote (")

Hi,

This is probably quite simple, but I am not able to make the following to work.

I would like to write a validation that checks for double quote characters, i.e:

NOT HAS_ANY_CHARS(my field, "%", "\"")

I guess the question is how I can escape the double quote?

Br, Olof

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 07, 2011 at 01:49 PM

    Hi Olof,

    I would like to write a validation that checks for double quote characters

    Unfortunately, We don't have direct way to achieve this special character "double quote characters" requirement.

    But you can write in this way if you want all chars to be Alphabets only.

    HAS_ALL_CHARS(my field, "A" , "z" )

    So in this way, it will allows only Alphabets only and give error in case of all special characters including double quote.

    Kindly revert if you need any other input.

    Regards,

    Mandeep Saini

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I did find a way to do a validation on a double quote (")

      Look at the acsii character code for double quote (in this case double quote = 34)

      http://www.ascii-code.com/

      Then do the validation as:

      NOT HAS_ANY_CHARS(my field,"34", "34")

      Best Regards

      Olof