RegEx spacing issues

[Sjkitts]

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 

[OllieClarke · Accepted solution]

@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!!!