Dynamic Rename Formula

I am looking to rename multiple columns into the same formatting with the dynamic rename tool however I am stuck when combining different variations.

Example of column names input:

t0_bw_column1__c

t0_column2__c

__column3__

Output:

TT_column1

TT_column2

TT_column3

I am able to use the replace formula to perform part of what I need for example replacing "t0_bw_" to "TT_" however cannot workout how to combine all the criteria into one expression.

Thanks

Tips and Tricks

Expression

Accepted answers

DataNath

Does something like this work better? Assuming that the extensive list above includes all of the possible current pre & suffixes. Could do this with regular string functions but would have to nest several as far as I can see.

Before

After

Dynamic field name change.yxmd

All comments

DataNath

@tom90 With the field names being somewhat unstructured, I'd look to use something like this, assuming there's always the 'columnX' part which is what you're looking for:

Regex_replace([_CurrentField_], '.+(column\d+).+', 'TT_$1')

Before

After:

tom90

Thanks for the reply

annoyingly the column name will change constantly.

It could be:

CreatedDate

LastEditedDate

ECT

DataNath

Can you provide a more extensive list of possibilities and what they should all be converted to? From your initial example it just looked like they were all ...ColumnX... but if not then the formula will definitely need more work or even extra tools to help standardise them.