Find and replace

[Kjaer]

Hi

I have a simple dataset, where I want to replace "PR" with "01" so PR-07-2021 becomes 01-07-2021. But how? I have tried "Find and replace" but no. The column is set as a v-string. 

[messi007 · Accepted solution]

@Kjaer,

You can do that with a formula :

Attached the workflow,

Regards

[Kjaer]

Thanks, it works :-)