Email address parse, RegEx?

[StephenMoss]

Hi 

I need some help parsing a list of email addresses. They are in two formats: 

monica.geller@aaa.com

chandler.m.bing@aaa.com

What I require is a separate first name and second name column and discarding the middle initial i.e:

First              Second

Monica         Geller

Chandler      Bing

Thanks for your help in advance! 

[OllieClarke · Accepted solution]

Hi @StephenMoss try this:

(.*?)\.(?:.*\.)?(.*?)@

in Parse mode

hope that helps,

Ollie

[StephenMoss]

This works very well indeed. 

Much appreciated! 

[MarqueeCrew]

Please try:

(\w+)\.*\w+\.(\w+)\@.*

inside of a regex tool to parse. 

cheers,

 mark

[arundaka02]

Hi @OllieClarke 

I have a similar query to @StephenMoss . The email address formats are the same but my desired output is slightly different:

Essentially I'd like to:

• Keep the middle initial
• Have the full name displayed in one column (first name, middle initial and surname)
• have the first letter of first and surname capitalised the middle initial capitalised too

Please can you help?

Many thanks!

KA

[OllieClarke]

Hey @arundaka02 try this formula in a formula tool:

TRIM(TITLECASE(REPLACE(REGEX_REPLACE([email],'@.*',''),'.',' ')))

Hope that helps,

Ollie 

[bb213]

@MarqueeCrew  your method above cuts off names.  For example, james.smith@xy.com,  the first name becomes "jame". 

[Ma3stro]

Hi @bb213,

If you have a bit of regex that is close to the desired output, you can play around with and test different regex configurations here: https://regex101.com/

It's 100% free and user friendly. I've found this site extremely useful lately.

Hope that helps!

[rohit782192]

Is there a Simple way to understand, Look like your parse finding difficult to understand.

I am a beginner in Regex.

[rohit782192]

Your regex is not working for me.

I want for

someone1234@gmail.com