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.
Solved! Go to Solution.
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