topic Re: How to replace string values in Alteryx Designer Desktop Discussions

How to replace string values

romachainani — Thu, 20 Jul 2023 20:05:53 GMT

I have a column that has these values:

abc_def

abc

lmn_op

lmn

In the example above:

I want abc and lmn to be capitalized but I want abc_def and lmn_op to remain as is:

abc_def

ABC

lmn_op

LMN

How would I go about doing this?

Thank you!

alexnajm — Thu, 20 Jul 2023 20:08:36 GMT

Formula should do the trick:

IF !Contains([Column],"_") THEN Uppercase([Column]) ELSE [Column] ENDIF

binu_acs — Thu, 20 Jul 2023 20:09:10 GMT

@romachainani One way of doing this

ShankerV — Thu, 20 Jul 2023 20:11:32 GMT

One way of doing this.

Many thanks

Shanker V

MilindG — Thu, 20 Jul 2023 20:10:50 GMT

romachainani — Thu, 20 Jul 2023 20:11:14 GMT

Thank you so much binuacs!