One additional note... if you wish to allow both uppercase and lowercase alpha
characters, you would need to use a more explicit qualification, e.g.:
'myField' LIKE "%[^A-Za-z]%"
----- Original Message -----
From: Thomas Bean
Newsgroups: gmane.comp.crm.arsystem.general
To: [email protected]
Sent: Wednesday, April 23, 2008 11:57 AM
Subject: Re: Error Message on Submit if a field has special characters.
**
Hi Mahesh,
The easiest solution, which doesn't require any workflow, would be to specify
the $ALPHA$ keyword as the pattern in the character field properties. This
will only allow alphabetic characters or blank spaces to be entered into the
character field, and will generate a generic error message upon submit if any
other characters are entered into the field.
Otherwise, if you prefer to use an active link or filter to generate a custom
error message, you can use a Run If qualification such as:
'myField' LIKE "%[^a-z]%"
This qualification should match any single character not within the range
[a-z].
HTH,
Thomas
----- Original Message -----
From: Mahesh
Newsgroups: gmane.comp.crm.arsystem.general
To: [email protected]
Sent: Wednesday, April 23, 2008 11:13 AM
Subject: Re: Error Message on Submit if a field has special characters.
**
Sorry hit the send button quickly. I have just used a similar qualification
for validating email addresses...
((NOT ('Email' LIKE "[EMAIL PROTECTED]")) OR (NOT ('Email' LIKE "%.%")))
I guess you can use a similar qualification.
On 4/23/08, Mahesh <[EMAIL PROTECTED]> wrote:
Hello Everyone
I have a character field for inputting the name of a person. I am trying
to write an active link that will throw an error message if that field has
special characters (anything apart from A - Z). What kind of a qualification do
I need to put in RUN IF.
Environment: ARS 7, SQL Server 2005, Custom Built HD
Appreciate your time and help in advance.
Thanks
Mike
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
