ASP.NET Forum

**higginbt** · 01-31-2006, 07:08 AM

Hi.

I have a recordset that contains email addresss as a string. However all i want to store is the characters before the @.

Is there a way of doing it in vbscript for ASP.

thanks.

**Minaki** · 01-31-2006, 10:03 AM

Code:

EMail = "my.email@domain.com"
 
AtPos = InStr(EMail, "@")
EMailName = Left(EMail, (AtPos - 1))

EMailName should now contain "my.email"

**higginbt** · 01-31-2006, 11:43 AM

Hi thanks i'd just figured out how to do that.
I just wasnt sure if there was an actuall command instead of just using the two.

THanks again for the answer

**chrishirst** · 02-01-2006, 09:21 AM

addArray = split(email,"@")

addArray(0) now contains the name.