Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Basic text replace

beadyeyesbb
7 - Meteor

hi i would like to conduct basic text replace where some of the felds = "Com" and some "Commodore"

 

I'd like to replace "Com" with "Commodore"

 

What would be the easiest way? 

 

Thanks,


Ben 

3 REPLIES 3
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @beadyeyesbb,

 

In a formula tool you could use the Replace() function:

 

REPLACE([FIeldToPerformOn], "Com", "Commodore")

 

 

Input:

Jonathan-Sherman_0-1589531753310.png

 

Output:

Jonathan-Sherman_1-1589531777808.png

 

 

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

 

Regards,

Jonathan

RolandSchubert
16 - Nebula
16 - Nebula

Hi @beadyeyesbb ,

 

if it's only this specific text, you can use a Formula tool. The more flexible option would be the FindReplace tool, espeically, if there is more than one text to replace. See attached workflow.

Let me know ifit works for you.

 

Best,

 

Roland

beadyeyesbb
7 - Meteor

thank you! 

Labels
Top Solution Authors