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

Parse

Accepted answers

Gawa

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/1206220#M299274

1238978_gawa.yxmd

Gawa

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.

1238978_gawa_Rev1.yxmd

All comments

Gawa

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/1206220#M299274

1238978_gawa.yxmd

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

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.

1238978_gawa_Rev1.yxmd

JenTe

It worked well. Thanks all for your support.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703