what about something like right(email, instr(email,'@')+1, len(email)) note: didn't test
On Mon, Jul 28, 2008 at 1:32 PM, Paul Ihrig <[EMAIL PROTECTED]> wrote: > i know i have done this befor > i am trying to get the values of an email address from right of the AT @ > symbol. > so far i can get the stuff from the left > then try to use replace to clear it out but next to my replace i still > am retuning the domain like @gmail.com > i just want gmail.com > > <cfset xclude = #SpanExcluding(getaUser.usr_email, '@')#> > <cfoutput> > Email: #getaUser.usr_email#<br /> > Exclude: #xclude# <br /> > Replace: #Replace(getaUser.usr_email, xclude, '')#<br /> > </cfoutput> > > > i tried #Replace(getaUser.usr_email, xclude@, '')# > but it freaks out on the @ > > thanks folks > > -paul > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309809 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
