General

Re: Infopath validation - simple Q

Hilary Stoupa — Fri, 05 Nov 2021 17:52:53 GMT

Awesome - thanks for adding these details! :)

Re: Infopath validation - simple Q

Daryl K — Fri, 05 Nov 2021 17:36:52 GMT

Also, for anyone else that reads this: I figured out what my error was with the previous format. The "zero or one," "zero or more" and "one or more" are modifiers, which must be added after the character pattern identifier.

For example, I was also trying to figure out how to require 4 numbers, with the option (not required) of an alpha afterwards. The proper way to enter this would be \d\d\d\d\p{L}?, where \d\d\d\d requires four numbers, \p{L} is one letter, but the ? is a modifier, meaning it will accept 0 or 1 instances of the letter.

In my first query the (other) way to do it would have been \d\d\d\d\d\d?, where the ? modifies the last number requirement, saying 0 or 1 instance is OK. in others words, 5 or 6 numbers would be accepted.

Re: Infopath validation - simple Q

Daryl K — Fri, 05 Nov 2021 00:38:29 GMT

Dang - it works great for me too! I wasn't even aware that was a valid way to type the validation formula (and apparently was using the wrong search terms since I never came across the article you cited).

As always Hilary you are awesome and I thank you for your help!

Re: Infopath validation - simple Q

Hilary Stoupa — Thu, 04 Nov 2021 21:33:06 GMT

This seems to work:

\d{5,6}

Found here: https://stackoverflow.com/questions/7864971/regular-expression-for-number-with-length-of-4-5-or-6

Infopath validation - simple Q

Daryl K — Thu, 04 Nov 2021 21:10:26 GMT

I am trying to do a basic validation in Infopath for a field that can only be a pattern of 5 or 6 numbers. I understand how to do the Data Entry Pattern validations, and 5 digits would be \d\d\d\d\d.

What I am having trouble with is the option of a sixth character. It may be there, it may not. Both are acceptable. If I use \d\d\d\d\d? it accepts 5 numbers but gives validation error on 6. The "special characters" lists "?" as "0 or 1" but it doesn't seem to work.

Is this option broken? Is there something I am missing?