The email address is not alway in order. Users are not alway have all three
emails address, some time one, or two. It dosen't matter howmay email address
they have, all I need is just find the email which contains domain @os.com.
Here is the example data I have and here are my two questions:
1) How would I output only the email have domain @os.com
2) If #1 is impossible to do it, then would I output all three emails and
sperate them by common (,) I tried the code below but I can't make it work.
Please help -thanks
******************************************************
<cfset email ="als@es.com: la.l.smi@escom: aa.l.smith@os.com added to E-mail
(subjectAltName) for.......>
<cfset fieldValue2 = mid(find('added','email',2),1,1)>
<cfoutput>#fieldValue2#</cfoutput>
Dan Bracuk - 29 Sep 2005 20:37 GMT
If in a query
where email like '%@os.com'
If in cold fusion
if(right(email, 7) is "@os.com")
do something