Prev: Number Format in Chart Datasheet
Next: How can I merge all my emails in outlook
From: Song on 9 Apr 2010 22:37
How to parse email and extract part that after @ sign?
From: GP George on 9 Apr 2010 23:15
Right([Email],Len([Email])-InStr([email],"@"))

That ought to do it.



"Song" <song.usa(a)gmail.com> wrote in message
news:ee627157-b840-4ce9-82d8-fdcee7aaa83b(a)q23g2000yqd.googlegroups.com...
> How to parse email and extract part that after @ sign?

From: John W. Vinson on 10 Apr 2010 01:34
On Fri, 9 Apr 2010 19:37:45 -0700 (PDT), Song <song.usa(a)gmail.com> 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]
From: Dirk Goldgar on 10 Apr 2010 01:34
"GP George" <george_hepworth(a)hotmail.com> wrote in message
news:20305D92-3F4C-4C48-B21F-C159487DBB77(a)microsoft.com...
> 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)

From: David W. Fenton on 10 Apr 2010 19:42
"Dirk Goldgar" <dg(a)NOdataSPAMgnostics.com.invalid> wrote in
news:A4A64D88-F016-4536-9420-03AA8C4D09E5(a)microsoft.com:

> 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/
 |  Next  |  Last
Pages: 1 2
Prev: Number Format in Chart Datasheet
Next: How can I merge all my emails in outlook