extract part of email after @

[Song]

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

 

[GP George]

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

That ought to do it.

 

[John W. Vinson]

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

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

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

 

[Dirk Goldgar]

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

That ought to do it.[/QUOTE]


Or

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

Or

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

 

[David W. Fenton]

Split(, "@")(1)[/QUOTE]

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

 

[Dirk Goldgar]

Split(, "@")(1)[/QUOTE]

Split() works in code, but not in a query.[/QUOTE]


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

 

[David W. Fenton]

Split(, "@")(1)[/QUOTE]

Split() works in code, but not in a query.[/QUOTE]

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

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

 

[Dirk Goldgar]

Split(, "@")(1)

Split() works in code, but not in a query.[/QUOTE]

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

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


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.