On 5/21/2012 2:47 PM, Kevin Davis wrote:
> Hi there,
>
> Here is what I'm trying to do.. I'm trying to merge the first and last name (that I can do) into an email address. But what I'm trying to do is to drop the middle initial. If the entry was from a form, I would have no problem, but the data will be uploaded from a different source, how would I go about dropping the middle initial?
>
> Would I use regex??
>
> Thank you,
> Kevin

I really hate to ask these because I fear the answers:

will there always be a middle initial ?

Will there be any first or last names with embedded spaces ? (eg
Jean Paul Aloysius Smith ?

bill