[How to] Remove String

I have a

1. field pokey containing 2024-2025-f-1216/001-f000004784-tan
2. field colour contains TAN

I wish to create field with  2024-2025-f-1216/001-f000004784

1. Basically lowercase #color -. This is possible
2. Concat - and collar - This is possible
3. Subtract or remove instance of -tan from pokey , is this possible ?

There are multiple ways of doing things as usual

You can use "Ensure No Suffi"x
www.etl-tools.com/wiki/advanced-etl-proc...gs/ensure-no-suffix/

or "Replace" 
www.etl-tools.com/wiki/advanced-etl-proc...ons/strings/replace/

But the value of color is dynamic , coming from a field.

At the moment I think the Calculation Transformation is the only option.

We might add a separate transformation for it in the future.

I love the usage of python/pascal in atypical scenarios such as above !!

Thank you so much for including them both  

For anyone in future going through this post ,the python calculation which works is 


Result.value = [F001].replace([F002], "")