populating text fields with a formatted name extracted from an e-mail address field

[databasewolfy]

Hello there. I have a large database with user e-mail addresses, but no way to conveniently display the user's name on the form.

E-mail formats as firstname.middleinitial.lastname.extraneousinfo@pl ace.domain

I have a first and last name field already in the table, but both are blank.

This is the only user data I have. How can I accomplish this?

[pbaldy]

See if this gets you started:

?split("firstname.middleinitial.lastname.extraneou sinfo@pl ace.domain",".")(0)
firstname
?split("firstname.middleinitial.lastname.extraneou sinfo@pl ace.domain",".")(2)
lastname