extract part of email after @

How to parse email and extract part that after @ sign?

Right([email],Len([email])-InStr([email],"@"))

That ought to do it.



"Song" wrote in message
...
How to parse email and extract part that after @ sign?

On Fri, 9 Apr 2010 19:37:45 -0700 (PDT), Song wrote:

How to parse email and extract part that after @ sign?

Mid([email], InStr([email], "@") + 1)

will work (the third argument to Mid is optional; if omitted it returns to the
end of the string).

--

John W. Vinson [MVP]

"GP George" wrote in message
...
Right([email],Len([email])-InStr([email],"@"))

That ought to do it.


Or

Mid([email], Instr([email], "@") + 1)

Or

Split([email], "@")(1)

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

"Dirk Goldgar" wrote in
:

Split([email], "@")(1)

Split() works in code, but not in a query.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

"David W. Fenton" wrote in message
36.98...
"Dirk Goldgar" wrote in
:

Split([email], "@")(1)

Split() works in code, but not in a query.


True, though I don't believe the OP specified that the expression needed to
work in a query.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

"Dirk Goldgar" wrote in
:

"David W. Fenton" wrote in message
36.98...
"Dirk Goldgar" wrote in
:

Split([email], "@")(1)

Split() works in code, but not in a query.

True, though I don't believe the OP specified that the expression
needed to work in a query.

No, but I think an answer to a question that's not specific needs to
account for both possibilities.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

"David W. Fenton" wrote in message
36.82...
"Dirk Goldgar" wrote in
:

"David W. Fenton" wrote in message
36.98...
"Dirk Goldgar" wrote in
:

Split([email], "@")(1)

Split() works in code, but not in a query.

True, though I don't believe the OP specified that the expression
needed to work in a query.

No, but I think an answer to a question that's not specific needs to
account for both possibilities.


Quite right. My first post was just to show a couple of other ways to skin
this cat (poor critter!), but it would have been better if I'd thought of
the query issue.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)