Split to Columns based on upper/lower case

[nickmartella]

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

[Prometheus]

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

 

[binuacs]

@nickmartella One way of doing this