Regex Help

[MROGK]

How can I use Regex to parse the below into 3 different columns?

AVERY 7-65H ND MC KENZIE

LANDPLUM 2-35H{ ND DIVIDE

PENELOPE 6-33H APO ND MC KENZIE

I need it as 

AVERY 7-65H                     ND       MC KENZIE

LANDPLUM 2-35H{            ND       DIVIDE

PENELOPE 6-33H APO     ND      MC KENZIE

[JosephSerpis · Accepted solution]

Hi @MROGK I mocked up a workflow that produces the output you describe. Let me know what you think?

[MROGK]

Thank you. What if I have strings with other states as well along w/ND, say MT, VT,etc. How do I need to add the other states to the expression? 

[JosephSerpis]

Hi @MROGK I amended the regex this version will split the string on the first occurrence of two uppercase characters with a space between them.