Parsing a word with uppercase letters

[JenTe]

Hi, need some help in parsing these words into output with space:

sample1 - TheCaves into The Caves

sample2 - TheSummit into The Summit

sample3 - VioletCamp into Violet Camp

sample4- TowerTown into Tower Town

sample5 - TheWollongMarket into The Wollong Market

[gawa · Accepted solution]

hi @JenTe 

You can try Regex tool like this. Please don't forget to uncheck "Case Insensitive".

FYI, please see this post for quick reference on how to write regex expression.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Sharing-RegEx-Cheat-Sheet/m-p/...

[aatalai]

to add to @gawa solution after the regex tool I would use the summarise tool, grouping by recordid and concatenating by Field 1 and put a space as a separator (if that doesn't work then use any symbol like _ and then the formula tool with a replace formula replacing the symbol with a space) if you want it all in one cell

[Ben_H]

Hi @JenTe,

An alternative solution is use the replace functionality to match only the upper character, and replace it with a space then itself.

You have to trim the result but it works without generating extra rows.

See below

Regards,

Ben

[gawa · Accepted solution]

Thanks to nice clarification by @aatalai , I understand precisely what @Ben_H wanted to do.

First of all, I should have assumed input data like this.

Based on this, I modified my WF as attached. Basic concept is not changed since first one, but as @aatalai said, result should be summarized in this way.

[JenTe]

It worked well. Thanks all for your support.