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
Solved! Go to Solution.
Looks like you are missing a \s in your Regex
[A-Z][a-z]+\s[A-Z][a-z]+|[A-Z][a-z]+