I have a column with the name 12345 Scenario: state case . I require the column to be renamed but only including the text 'Scenario: state case'
You could also use a Dynamic Rename Tool with a formula, like this. I used regex replace to remove the numbers and space, but you could use any Text function that can capture the bits you need to remove (or keep).
Hi @Mancunian ,
How do you desire to do that? Because with a select tool you can configure your column headers as you wish.
Best,
Fernando Vizcaino
I should have mentioned that the header might sometimes have a number e.g. 12345 Scenario5: state case.
