Rename column header

[Mancunian]

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'

[fmvizcaino]

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

[DavidP · Accepted solution]

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).

[Mancunian]

I should have mentioned that the header might sometimes have a number e.g. 12345 Scenario5: state case.

[Thableaus]

Hi @Mancunian 

Use the same Dynamic Rename tool as @DavidP mentioned, but instead, use this formula

REGEX_Replace([_CurrentField_], "[0-9]","")

Thanks,