Replacing Characters

Hello all,

I have data in a column "Cost Center" that I am trying to replace with nothing, so deleting the text. What I am looking to do is find and replace CTV1 with nothing, then A1000 with nothing, and A1001 with nothing. This text is all in the same column.

Thank you!

Workflow

Accepted answers

atcodedog05

Hi @MOlinski

Here is how you can do it. Check and let me know does this work for you.

Workflow:

Hope this helps : )

replace.yxmd

All comments

atcodedog05

Hi @MOlinski

You can use formula like this

IF [Cost Center] in ("CTV1","A1000","A1001")
THEN Null()
ELSE [Cost Center]
ENDIF

If it doesnt work can you please provide sample data.

Hope this helps : )

MOlinski

I apologize, I should of mentioned that there is no spaces between the data, it is all combined. I can't provide my workflow because it is sensitive data, but I can provide a screen shot of what I am trying to remove. What I would like to do is remove the highlighted from the data below.

Thank you!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703