Print everyhing before and after at

Hi!
If i get an email adress from a database like this <%= rs("email") %> and it contains the adress mc@pz-net.com. How do i do if i want to break up this in two variables one that is called user which contains mc and one called domain that includes pz-net.

With other words i want one variable with everything before at (@) and one from everyhing after.
MickeCAsked:
Who is Participating?
 
Wayne BarronConnect With a Mentor Author, Web DeveloperCommented:
Forgot something
For your code, you will need it to be like so.

email = rs("email")
getName = Left(email,InStr(email,"@")-1)
chDomain = Mid(email,instr(email,"@")+1)

Open in new window


Carrzkiss
0
 
Wayne BarronAuthor, Web DeveloperCommented:
Here is what I use, and it works pretty well.

getName = Left(email,InStr(email,"@")-1)
chDomain = Mid(email,instr(email,"@")+1)

Open in new window


Good Luck
Carrzkiss
0
 
IronhoofsCommented:
Use the split() function

var sMail = rs("email")
var aMail = split(sMail, "@")
var sUser = aMail[0]
var sDomain = aMail[1]
0
 
Wayne BarronAuthor, Web DeveloperCommented:
Glad I could help.
This code is a life saver, big time.

Take Care
Carrzkiss
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.