Oh yeah, numbers should be allowed. Thanks for the suggestion. On Wed, Apr 23, 2008 at 3:26 PM, Thomas Bean <[EMAIL PROTECTED]> wrote:
> ** You may want to allow for numeric characters in the e-mail address as > well. If so, just modify the 'Run If' qualification in the first active > link to the following: > > 'Email' LIKE "[EMAIL PROTECTED]" > > > ----- Original Message ----- > *From:* Mahesh <[EMAIL PROTECTED]> > *Newsgroups:* gmane.comp.crm.arsystem.general > *To:* [email protected] > *Sent:* Wednesday, April 23, 2008 1:41 PM > *Subject:* Re: Error Message on Submit if a field has special characters. > > ** 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___ > > > > > > > > __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"
