Okay, thanks - and the 2nd requirement doesn't really require multiple active links/filters - just string the queries for ampersands together with OR: (query) OR (query) OR (query).
David D. > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W > Sent: Wednesday, September 11, 2013 9:16 AM > To: arslist@ARSLIST.ORG > Subject: Re: Email Id validation in remedy > > And the first could be written as LIKE "% %" > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling > Sent: Wednesday, September 11, 2013 8:10 AM > To: arslist@ARSLIST.ORG > Subject: Re: Email Id validation in remedy > > ** > Sorry, correction on 2nd requirement query: > > 'Email Address' LIKE ("%@%@%") AND (NOT('Email Address' LIKE "%;%")) and > throw an error > > David Durling > > -----Original Message----- > 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 > > -----Original Message----- > 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 > 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 > > __________________________________________________________ > _____________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "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"
