Trim Character out of a column header

[garretwalters12]

I am trying to Trim the first two characters of the column header (# and _) and would also like to remove all "_" which makes up the spaces.

Expected column headers:

June 2019

May 2019

Variance to Previous Month

June 2018

etc.

[LukeM · Accepted solution]

Hi @garretwalters12 

If you leverage the use of the Dynamic Rename tool, you can use a formula to update the column headers.

This would look like:

Trim(
Replace(
Right([_CurrentField_],Length([_CurrentField_])-1)
,'_',' ')
)

Which replaces the '_' with nothing and takes everything from the right except for the first value.

Hope this helps.

Luke