Support Forums : Sample Pattern Rules?

I’m trying to control the possible answers for a given question by using the Pattern Rules in the Validation section. (I need the user to see an immediate “error” message or alert as they enter the information…can’t wait until user hits “submit”.)

Here are the rules I have so far:
–For a number 1-4 digits in length:
\d{1,4}

–For a whole number percentage with % sign:
\d{1,3}%

–For a three letter month:
Jan|Feb|Mar|May|Jun|Jul|Aug|Sept|Oct|Nov|Dec

(Reproduced here for the benefit of others)

Here are the other rules I’d like:
–require the user to submit info in currency
–require the user to submit an email address
–require the user to submit a phone number

Thanks!

Good catch!

The multi-text questions now allow for the same pattern matching behavior. Plus, here are your other patterns. BTW. You may need to add a ^ to the beginning of your patten and a $ to the end to get them to work more preceisely.

So the 4 digit pattern would be: ^\d{1,4}$

Here are the others you wanted (brace yourself!):

Currency: (with commas dollar sign and cents)
^\$?([1-9]{1}[0-9]{0,2}(\,[0-9]{3})*(\.[0-9]{0,2})?|[1-9]{1}[0-9]{0,}(\.[0-9]{0,2})?|0(\.[0-9]{0,2})?|(\.[0-9]{1,2})?)$

Email Address:
^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$

US Phone Number:
^((\(\d{3}\) ?)|(\d{3}[-\s]))?\d{3}[-\s]\d{4}$

You’re right Jennifer. We don’t currently have validation working on text fields in a table like this yet.

Hi Jennifer,

Sorry it took us a few days to get to this. This post slipped through the cracks.

There is the RegEx you need:

^((([5-9][0-9],[0-9]{3,3})|(\d,(\d\d\d,){0,5}\d\d\d,\d\d\d))|(([5-9]\d{4,4})|(\d{6,12})))$

The reason it looks so complex is because it need to handle numbers with commas and numbers without commas :)

-Christian

I found the answer to my question from someone else on my team. For anyone who’s interested, the following seems to work.
^(([D-Jd-j]{1}[A-Ja-j]{1})|([04-9]{1}[0-9]{1}))[0-9]{5}$

I didn’t specify in my original question that the first digit had to be either D,E,F,G,H,I,J OR 0,4,5,6,7,8,9