Split to Columns based on upper/lower case

Question

Hello, I am trying to split up a description column based on upper and lower case.
example:

DESCRIPTION

PITTSBURGH             Pittsburgh motors front swivel caster jet

URBANA IN MARYLAND          Urbana maryland motors

How can I get this column split up? these are just two examples but all the rows have varying lengths but in this upper case to lower case format. Thanks!!!!!

binu_acs · Answer

@nickmartella One way of doing this

Regex_210923.yxmd

Prometheus · Answer

@nickmartella I used the RegEx tool's Parse function to create two new fields called Uppercase and Lowercase and used this expression: (^[A-Z]+.*)([A-Z][a-z]+.*)

www.regex101.com is great for learning Regular Expressions.

Parse to Columns.yxmd