Using Cold Fusion to do it, or in MSAccess itself?
If Cold Fusion, here's a cool trick:
<cfset myUser = ListFirst(emailAddress,'@')>
<cfset myDomain = ListLast(emailAddress,'@')>
I love using this :)
Jeff Beer
Senior Programmer Architect
Hydrogen Media, Inc
(727) 530-5500 x303
[EMAIL PROTECTED]
> -----Original Message-----
> From: Troy M. Wussow [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 28, 2001 2:28 PM
> To: CF-Talk
> Subject: OT: HELP PLEASE! MS Access Trim Statement
>
>
> I am trying to separate an e-mail address from the domain -
> everything to
> the right of the "@" symbol. I have 2 database fields named
> [Email] and
> [Domain] and I am trying to use either a MID or TRIM
> statement to copy just
> the domain information into the [Domain] Field.
>
> Any suggestions would be greatly appreciated!!!
>
> Troy Wussow
> Web Developer - MIS
> National Seminars Group
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
