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