Sorry, correction on 2nd requirement query:

'Email Address' LIKE ("%@%@%") AND (NOT('Email Address' LIKE "%;%")) and throw 
an error

David Durling

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling
Sent: Wednesday, September 11, 2013 9:09 AM
To: arslist@ARSLIST.ORG
Subject: Re: Email Id validation in remedy

**
Sagar,

I'm not going to write the exact queries, but I think  'Email Address' LIKE 
("%" + " " + "%") with a space in the quotes will find any spaces.

There might be better ways to do this, but to meet the 2nd requirement you 
could look for something like 'Email Address' LIKE ("@%@") AND (NOT('Email 
Address' LIKE "%;%")) and throw an error.  If the field is long enough to 
contain more than just 2 addresses, you might have to have multiple active 
links/filters - one to check for 3 addresses by looking for three @ signs 
missing 2 semicolons, another to check for 4 addresses missing 3 semicolons, so 
forth.

David Durling
University of Georgia

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of vidyasagar kommu
Sent: Wednesday, September 11, 2013 2:14 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Email Id validation in remedy

**

Hi All,

Could you please guide how to do the below requirements .

Requirment1 : Whenever there is a Space  Email Address remedy  should not allow 
to create or save the form .
This space could be at any place in the email field, could be at the beginning 
,middle or end of the email ID.
So ideally this field should not accept a space anywhere in the field.

Requirment2:If there are two or more email ID 's in the email  field then those 
should be separated by a semicolon (;), so if there is no semicolon (;) between 
two email addresses then remedy should not allow to save form It should throw 
any error message
Requesting you provide the suggestion on this.
Thanks in advance

Thanks
Sagar
_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Reply via email to