Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to get sring to right of @

Status
Not open for further replies.
Moss100

Moss100

Technical User
Joined
Aug 10, 2004
Messages
586
Location
GB
Hello,

I have a field [EmailAdd].

I want to extract the email address after the @ for each record. So mandy56@hotmail.com would just return hotmail.com

How do I approach this?

Many thanks Mark
 
Sort by date Sort by votes
This seems to work:

Mid([EmailAdd],InStrRev([EmailAdd],"@")+1)

Regards Mark
 
Upvote 0 Downvote
I would typically start from the left:

Code: 
Mid([EmailAdd],InStr([EmailAdd],"@")+1)

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
8
Views
780
breezett93
breezett93
C
  • Locked
  • Question Question
Query expression negative to a 0
Replies
6
Views
749
dhookom
dhookom
Swi
  • Locked
  • Question Question
Select X of each variation of a field
Replies
8
Views
867
rashmibala
R
mhshane
  • Question Question
Is this the best way to do this query?
Replies
9
Views
605
mhshane
mhshane
TheresAlwaysAWay
  • Question Question
Why does what appears to be a simple append query is pasting 5 duplicate rows?
Replies
9
Views
272
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top