SOLVED
Dynamic Rename - Remove prefix using "%" wildcard?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
msedrech0114
7 - Meteor
‎12-10-2018
12:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Developer Tools
2 REPLIES 2
17 - Castor
‎12-10-2018
12:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)
‎12-10-2018
12:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you Charlie S, it works!
