Parsing names, Text to columns however people with hyphenated names are not correct

Question

Hello,

I am trying to do a parsing of names, however people with hyphendated names do not look correct.

"IS PALMER -" is correctly parsed to IS PALMER

however "IA GREGORY-SMITH-" is parsed to IA GREGORY.. but im missing the SMITH.

can anyone help with this?

Matthew · Answer

or instead of parsing, use the regex tool's "tokenize" method

([a-zA-Z\-]+)

Matthew · Answer

something that may work:

([a-z A-Z]*\-?[a-zA-Z]+)\s([a-z A-Z]*\-?[a-zA-Z]+)

DataNath · Answer

How's this? Expression is: (.+)-

Literally just parses everything up until the last instance of '-'. Workflow attached.

Parse until last -.yxmd