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?

Developer Tools

Regex

Parse

Accepted answers

MarqueeCrew

@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

Titlecase to underscore.yxmd

atcodedog05

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 😀👍

underscore.yxmd

All comments

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/m-p/596042#M132700

MarqueeCrew

@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

Titlecase to underscore.yxmd

MarqueeCrew

@joshuaburkhow ,

OMG! How impressive to use so many tools.

Cheers,

Mark

atcodedog05

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 😀👍

underscore.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703