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! 

[PhilipMannering]

Hi @rohit782192 what's your desired output for "someone1234@gmail.com"? A first name and a last name? What would that be here?

How many cases do you have? Very often a solution that works for "someone1234@gmail.com" will not work for another email address, so it's very helpful to know exactly what output you require and to have a sample of data that you want to process. If you provide this I am convinced we can find regex that will work for you.

All the best,

Philip

[rohit782192]

Hey Philip,

I have also tried

someone1234@gmail.com

(\w+)@(\w+).(\w{3})

Correct how should i improve more.

Email                                   RegExOut1      RegExOut2 RegExOut3
someone1234@gmail.com someone1234  gmail            com

[MarqueeCrew]

@StephenMoss ,

 if you have $ budget, I can refer you for sales of reverse email append data. 

cheers,

 mark