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!
Solved! Go to Solution.
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 : )
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!
Please see below and thank you for the help.
Actual Data | Expected Output |
CTV130095A1001 | 30095 |
CTV160054A1001 | 60054 |
CTV160093A1001 | 60093 |
Thank you,
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!
Hi @MOlinski
Here is how you can do it. Check and let me know does this work for you.
Workflow:
Hope this helps : )
This worked!!! Thank you so much for the help.
Happy to help : ) @MOlinski
Cheers and have a nice day!