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 Chris Miller 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
Aug 10, 2004
586
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

serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
672
serino
serino
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
1K
dhookom
dhookom
btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
1K
combo
combo
caykamanj1966
  • Locked
  • Question
Get Yesterday's Date
Replies
1
Views
208
caykamanj1966
caykamanj1966
TheresAlwaysAWay
  • Locked
  • Question
Can not get Access 2016 queries to accept form value input or TempVars! input 2
2
Replies
21
Views
578
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top