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
Solved! Go to Solution.
Hi @Drole you can with the Dynamic Rename I've mocked up a workflow let me know what you think?
Hi @Drole , you can use this as well incase you just want to replace Delta_20 with Delta_.
The regex expression used by @JosephSerpis
\w{5}_\d{2}
\w is used to parse the word character and {5} is the limit to fetch Delta
_ is used to match your character string.
\d is used to parse digit and {2} is the limit to fetch first two digits that is 20 from the string.\
Therefore, this expression will look for Delta_20 and will replace with Delta_ as used in the regex replace function.
Note: For better understanding you can visit regexr.com where you can learn about the regex.
I hope it helps.
Thanks.