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
Solved! Go to 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.
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
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
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.
It worked well. Thanks all for your support.