That worked. Thanks Thomas.
On 4/23/08, Thomas Bean <[EMAIL PROTECTED]> wrote:
>
> In that case, I think I would probably use two separate active links.
>
> Active Link 1:
> Run If: 'Email' LIKE "[EMAIL PROTECTED]"
> If Action: Error Message (e.g., "E-mail address contains invalid
> characters...")
>
> Active Link 2 (*higher execution order*):
> Run If: NOT ('Email' LIKE "[EMAIL PROTECTED]")
> If Action: Error Message (e.g., "E-mail address is formatted
> incorrectly...")
>
> The first active link would throw an error if any non-alpha characters
> (excluding "@" and ".") are entered into the e-mail address field.
>
> The second active link would throw an error if the field value isn't
> formatted as *[any valid [EMAIL PROTECTED] valid string].[any valid string]*.
>
> If you use the ARFPerl plugin, you might also be able to use a Perl module
> such as
> *Email::Valid<http://search.cpan.org/~rjbs/Email-Valid-0.179/lib/Email/Valid.pm>
> * to perform the validation for you in a filter.
>
> --Thomas
>
>
> ----- Original Message -----
> *From:* Mahesh <[EMAIL PROTECTED]>
> *To:* Thomas Bean <[EMAIL PROTECTED]>
> *Sent:* Wednesday, April 23, 2008 12:52 PM
> *Subject:* Re: Error Message on Submit if a field has special characters.
>
>
> Hello Thomas
>
> Actually I am looking for syntax for validating email. If I use ALPHA for
> email, it wont accept "@" or ".". So is the reason I was using the following
> in the RUN IF of an active link
>
> ((NOT ('Email' LIKE "[EMAIL PROTECTED] <[EMAIL PROTECTED]>")) OR (NOT
> ('Email' LIKE "%.%")))
>
> Please advise if there is better way to do this.
>
> Mahesh
>
> On 4/23/08, Thomas Bean <[EMAIL PROTECTED]> wrote:
> >
> > ** 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 <[EMAIL PROTECTED]>
> > *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] <[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"
