Replace Characters in the middel of a string

Hi there,

I have a data set that has a lot of coulmns, and I want to change the name of these columns, but i do not want to do i manually.

Is there a way were I can rename Delta_2015, Delta 2016.... etc. to be Delta_15, Delta_16,..., Delta_22.

So I want to replace 20 for all colums with blank.

Thanks

Workflow

Expression

Accepted answers

Hi @Drole you can with the Dynamic Rename I've mocked up a workflow let me know what you think?

Hi @Drole you can with the Dynamic Rename I've mocked up a workflow let me know what you think?

In the attached example I changed Field Names from:

to:

Hope that helps.

That helped, thanks 🙂 Could you explain the expression you used?

Best regards