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

[wonka1234]

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?

[DataNath]

RegEx sounds like it will be your best bet here. Are you able to provide a comprehensive list of the possibilities within the field? And what parts you need to parse out, along with any patterns that always occur, if any? Then we can build an expression!

[wonka1234]

@DataNath 

Pretty much the logic would be Parse the field on the last found "-"

[DataNath]

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

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

[Matthew]

something that may work:

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

[Matthew]

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

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