RegEx spacing issues

I'm currently having trouble getting some people's first names disappearing when I try using this Reg Ex Tool. I've split one column into two columns to make a first name column and a last name column but am still seeing some first names not come up. See screenshots below. What RegEx statement would be best or if there was another tool/component that would do this for me what would it be?

Screenshots

Text to Column
RegEx
Overall Issue
Column that I'm trying to split up

Alteryx_Reg_Ex.JPG

Alteryx_Text_to_columns.JPG

Alteryx_issue.JPG

Alteryx_Column_that_im_splitting_up.JPG

Datasets

Accepted answers

OllieClarke

@Sjkitts If you want to split based on a space into 2 columns, then use the text to columns tool, but put

\s

as the delimiter, rather than ','

If you want your RegEx to do the same, then

(.+?)\s(.+)

will create two columns splitting on the first space it finds.

Hope that helps,

Ollie

All comments

OllieClarke

@Sjkitts If you want to split based on a space into 2 columns, then use the text to columns tool, but put

\s

as the delimiter, rather than ','

If you want your RegEx to do the same, then

(.+?)\s(.+)

will create two columns splitting on the first space it finds.

Hope that helps,

Ollie

Christine_Assaad

Hi @Sjkitts

To add to what @OllieClarke mentioned, make sure that original data has a clear pattern. If a space or comma is missing this could lead to empty F.Name and/or L.Name.

Sjkitts

Thank you very much!!!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703