Parse Email String (Access 2K/XP)

Topic

New Reply

I’m trying to separate a field [Responder] into 2 fields. Brand and name.
The format of the emails is:
anyaddress@anydomain(pontiac_john_doe).com
anyaddress@anydomain(chevy_john_smith).com
I got the brand to work by using:
Mid([responder],InStr([Responder],”(“)+1,(InStr([responder],”_”)-1)-(InStr([Responder],”(“)))
I don’t see how to use instr to find the second “_” in the string to separate the name.
Can someone point me in the right direction.
Thanks,
Scott

Reply | Quote

Replies

To return “john”:

Mid([Responder], InStr([Responder], “_”) + 1, InStr(InStr([Responder], “_”) + 1, [Responder], “_”) – InStr([Responder], “_”) – 1)

To return “doe” or “smith”:

Mid([Responder], InStr(InStr([Responder], “_”) + 1, [Responder], “_”) + 1, InStr(InStr(InStr([Responder], “_”) + 1, [Responder], “_”) + 1, [Responder], “)”) – InStr(InStr([Responder], “_”) + 1, [Responder], “_”) – 1)

Reply | Quote

Hans,
Thanks, I never thought to nest the Instr together like that. That’s what I get for trying to use the help files.
Scott

Reply | Quote

Hans,
Thanks, I never thought to nest the Instr together like that. That’s what I get for trying to use the help files.
Scott

Reply | Quote

To return “john”:

Mid([Responder], InStr([Responder], “_”) + 1, InStr(InStr([Responder], “_”) + 1, [Responder], “_”) – InStr([Responder], “_”) – 1)

To return “doe” or “smith”:

Mid([Responder], InStr(InStr([Responder], “_”) + 1, [Responder], “_”) + 1, InStr(InStr(InStr([Responder], “_”) + 1, [Responder], “_”) + 1, [Responder], “)”) – InStr(InStr([Responder], “_”) + 1, [Responder], “_”) – 1)

Reply | Quote