Replacing Characters

[MOlinski]

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!

[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!

[atcodedog05]

Hi @MOlinski 

Can you the same screenshot data in excel and expected output.

[MOlinski]

Please see below and thank you for the help.

Actual Data	Expected Output
CTV130095A1001	30095
CTV160054A1001	60054
CTV160093A1001	60093

Thank you,

[atcodedog05]

Hi @MOlinski 

I would suggest find and replace for this approach.

Workflow:

Hope this helps : )

[MOlinski]

Sorry, but I'm still not sure I am understanding. There will be thousands and thousands of cost center fields and this data will be changing every time the report is ran. What I did was got rid of all of the sensitive data so please see attached and let me know if that helps. Thank you again!

[atcodedog05 · Accepted solution]

Hi @MOlinski 

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

Workflow:

Hope this helps : )

[MOlinski]

This worked!!! Thank you so much for the help.

[atcodedog05]

Happy to help : ) @MOlinski 

Cheers and have a nice day!