Basic text replace

[beadyeyesbb]

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 

[Jonathan-Sherman · Accepted solution]

Hi @beadyeyesbb,

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

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

Input:

Output:

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]

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]

thank you!