Adding "_" delimiter between lower case and upper case

[cmyer]

Hi Alteryx Community, 

I am trying to change the format of my values. 

For example-my current field looks something like this:

Column

ValueNumberOne

ValueNumberTwo

ValueNumberThree

I would like to change the values in that column to have a "_" between each word as such:

Column

Value_Number_One

Value_Number_Two

Value_Number_Three

please note: my values are not all equal length 

Does anyone know how to achieve this? 

[joshuaburkhow]

Hey @cmyer 

I use a version of what @Jonathan-Sherman  uses here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/split-by-upper-case-before-lower-case/...

[MarqueeCrew · Accepted solution]

@cmyer ,

I don't know how @joshuaburkhow solved this (I haven't looked), but this is how I would:

Use a RegEx tool to find the switch in case and tokenize the data.  Then use a Summarize tool to rebuild.

Cheers,

Mark

[MarqueeCrew]

@joshuaburkhow ,

OMG!  How impressive to use so many tools.

Cheers,

Mark

[atcodedog05 · Accepted solution]

Hi @cmyer

Here is a workflow for the task.

Formula

REGEX_Replace([Text], "(\l)(\u)", "$1_$2",0)

\l - lower case

\u - uppercase

adding _ between them

0 - case sensitive search

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[MarqueeCrew]

Maybe he'll mark all as solutions, but only give likes to me. 

[cmyer]

*She marked all as solutions lol

YOU GUYS ARE GREAT!!! 

thank you so much 🙂

[atcodedog05]

Happy to help 🙂 @cmyer 

Cheers and Happy Analysing 😀

Feel free to reach out if you face any issues 🙂