General

Re: Disallowing user to enter special charecters

javicartin — Wed, 16 Dec 2015 20:37:06 GMT

Hello Hilary, thank you for your great answers,

I would like to meet this expression.

On the field, I have this expression: nnn/nn-nn-nnn-nnWn

Now, on the rule, I have the following, but now I require that the user can put a number or a letter, please see attachment, what could be the expression to use any number/letter, like changing \d into .

Thanks again

Re: Disallowing user to enter special charecters

srikrushna — Tue, 09 Dec 2008 08:20:43 GMT

Bingo,

I tried with this expression :

\p{L}*\d*|\d*\p{L}*|[\p{L}\d]*

Working fine !

Re: Disallowing user to enter special charecters

srikrushna — Mon, 08 Dec 2008 10:34:28 GMT

Hi Swathip,

Fails for these values : a1a1,sa1sa1.

Basically I am looking for an expression which should not fail for any combination of characters and letters.

Re: Disallowing user to enter special charecters

swathip — Mon, 08 Dec 2008 10:03:52 GMT

Hi,

To accept the above patterns use the following expressions with or (|) including the above the expressions.

\p{L}*\d*\p{L}*

\d*\p{L}*\d*

The total expression is like

\p{L}*\d*|\d*\p{L}*|\p{L}*\d*\p{L}*|\d*\p{L}*\d*

Re: Disallowing user to enter special charecters

srikrushna — Mon, 08 Dec 2008 09:44:44 GMT

Hi Hillary,

The above pattern fails for these values : s1s,1a1,sa1s

Any suggestions on this would be appreciated !

Re: Disallowing user to enter special charecters

Hilary Stoupa — Fri, 18 Jul 2008 14:19:49 GMT

Hello:

The following pattern allows only letters and digits, in any order (you can begin with letters or with digits). It allows no other characters, however, including the space character:

\p{L}*\d*|\d*\p{L}*

I used the Insert special character dropdown in the Data Entry Pattern window to select the following:

Any letter: \p{L}
Zero or more: *
Any digit: \d
Zero or more: *

I then added a pipe ( | ) for "or" and reversed the pattern so that the field could begin with a letter or a number.

Hope that helps!

Re: Disallowing user to enter special charecters

doug.hay — Mon, 14 Jul 2008 19:51:34 GMT

Any suggestions on creating a pattern that will allow any combination of letters or numbers but disallow any special characters.

Re: Disallowing user to enter special charecters

Hilary Stoupa — Fri, 20 Jun 2008 16:10:28 GMT

Hi, Vipul:

You can use data validation. Select Data Validation for the field you wish to limit input on, select Add in the Data Validtion window for Conditions. In the first dropdown you will have the field you have currently selected, in the second, select "does not match pattern" and in the third dropdown select "Select a pattern". The Data Entry Pattern window opens, and it already has a phone number pattern defined that you can use. Add screen tip and message for your user when data is entered incorrectly and then preview your form and test by entering incorrect data.

Disallowing user to enter special charecters

mehtavipulk — Wed, 11 Jun 2008 10:26:50 GMT

Hi,

On my InfoPath form I have a Phone Number field. The business requirement is that the user should only be allowed to enter numbers, -, (, ) (i.e. user should only allowed to enter numbers, hyphen, opening bracket & closing bracket).

In general how do I prompt user when user enters special charecters which we do not want them to enter.

Regards,

Vipul Mehta