How can I extract the domain( everything from the @ and to the ri.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create a query that will extract the domain, everything to the
right of the "@". I have been using trying to use the Mid function but need
to embed an additional function to return the character postion of the "@".
In excel I would use the search fuction but Access doesn't seem to have this.

Any help?
 
NewUser said:
I'm trying to create a query that will extract the domain, everything to the
right of the "@". I have been using trying to use the Mid function but need
to embed an additional function to return the character postion of the "@".
In excel I would use the search fuction but Access doesn't seem to have this.
Click to expand...
<snip>

Try Expr1: Right$([E-mail],Len([E-mail])-InStr(1,[E-mail],"@")-0)

Roxie Aho
roxiea at usinternet.com
 
Roxie Aho said:
NewUser said:
I'm trying to create a query that will extract the domain, everything to
the
right of the "@". I have been using trying to use the Mid function but
need
to embed an additional function to return the character postion of the
"@".
In excel I would use the search fuction but Access doesn't seem to have
this.
Click to expand...
<snip>

Try Expr1: Right$([E-mail],Len([E-mail])-InStr(1,[E-mail],"@")-0)
Click to expand...

Or, more simply, Mid$([E-mail], InStr([E-mail], "@") + 1)
 
Back
Top