Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Long String data in one column

GarMIngle
8 - Asteroid

See Below: 

I am using RegEx tool parse the All produces Category into rows.  See data before and data after tool application.  I want Office Supplies in one row not two. I will apply the summarize tool after this application.

 

Thanks

 

1 REPLY 1
joshuaburkhow
ACE Emeritus
ACE Emeritus

Looks like you are missing a \s in your Regex

 

[A-Z][a-z]+\s[A-Z][a-z]+|[A-Z][a-z]+

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
Labels