Using RegEx for spacing

[Eva_A_Garcia]

I trying to split a column that has the following:

Joe Public joe.q.public@zoo.com 

I need to be able to split name and email (mainly the email address).

Any help is appreciated; thanks!

[fmvizcaino · Accepted solution]

Hi @Eva_A_Garcia ,

Here is an expression that solves your issue. (.*?)\s([^\s]+@.*)

I've used the parse method from the regex tool

Best,

Fernando Vizcaino

[Eva_A_Garcia]

Thank you Fernando that worked perfectly. I do appreciate your quick response.