parsing text in a text field

[skuli]

Hi, I'm hoping someone can give me a hand and show me how I can parse and email address into 2 fields. I need to get all the data before the "@" sign into the first field and everything after the "@" into the second. I can get this to work if it is a simple email address, but not if it is something like: name.lastname@ xyz.com or name_lastname @xyz.com or [email protected]. Any help is appreciated.

[Fitch]

Left(email, Position(email, "@", 1, 1) - 1)

Right(email, Length(email) - Position(email, "@", 1, 1))

[skuli]

Well, I was close... Thank you so much for your help.