topic Re: Split to Columns based on upper/lower case in Alteryx Designer Desktop Discussions

Split to Columns based on upper/lower case

nickmartella — Thu, 13 Jun 2024 21:56:20 GMT

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

Re: Split to Columns based on upper/lower case

Prometheus — Thu, 21 Sep 2023 15:26:59 GMT

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

Re: Split to Columns based on upper/lower case

binu_acs — Thu, 21 Sep 2023 21:26:44 GMT

@nickmartella One way of doing this