Dynamic Rename - Remove prefix using "%" wildcard?

msedrech0114

Is there any way for dynamic rename tool to apply a wild-card?

In a cross-tab output, I want the date columns to be sorted hence I prefix the date. But in the end, I want to dynamically rename columns to remove the prefix "_Test_%" (i.e. remove all strings preceding "_Test_" so only Dec_2017, Jan_2018, so on remain as column names. 

2017_12_01_Test_Dec_2017

2018_01_01_Test_Jan_2018

2018_02_01_Test_Feb_2018

Any suggestions.

Greatly appreciate your help.

Thank you
Mark

CharlieS

Since the prefix string is a set length, you could just remove the first 16 characters of the names.

Dynamic Rename Formula: 

substring([_CurrentField_],16) or right([_CurrentField_],8)