Newbie Questions

Re: Custom Patterns for every character except %, <, >

mjaneczk — Fri, 05 Sep 2008 18:36:11 GMT

I should have read your post first! :-)

That works. Sometimes I miss the obvious. Thanks!

Re: Custom Patterns for every character except %, <, >

mjaneczk — Fri, 05 Sep 2008 18:32:56 GMT

When I use \x20 (for instance), I get an invalid pattern. Is there a special way in which to specify ASCII?

Re: Custom Patterns for every character except %, <, >

Anuma — Fri, 05 Sep 2008 07:06:54 GMT

Hi,

You can use following data validation:

Field contains “<” or Field contains “>” or Field contains “%”

Enter your validation message in Screen tip text box and click on ok.

Re: Custom Patterns for every character except %, <, >

ravig — Fri, 05 Sep 2008 04:00:53 GMT

Hi mjaneczk,

Write data validation using ASCII values of the characters.

Custom Patterns for every character except %, <, >

mjaneczk — Thu, 04 Sep 2008 18:28:40 GMT

I need to write a data validation for a field which can't have a %, <, or > character. I essentially want to prohibit anyone from entering HTML code in a field, hence the <,> and % characters.

How would I write that pattern? I have something like this so far:

[A-Za-z0-9 \-\.,\(\)]+

But I get Invalid Pattern when I enter \&, \*