Regex to convert email to regular name

[wonka1234]

Hi,

Is there a way to use regex to change email format from:   "JOHNSMITH@GMAIL.COM" to JOHN SMITH?

Thanks.

[MarqueeCrew]

@wonka1234 ,

A better question might be what to do with:

SAMISMITH@gmail.com

Is it Sam I Smith or Sami Smit?

If you have a ROBUST list of last names, you could parse the names based upon the known last names and break it up that way.

Cheers,

Mark

[EN6924]

[OllieClarke]

@EN6924 The problem with this approach is you've baked in the assumption that all first names are 4 letters long and all surnames are 5 letters long. Like @MarqueeCrew says without a list of names there is no way to robustly parse the email into first names and surnames...