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"
