Remove Trailing and Leading Spaces in Field Names

[poles1c]

Hi,

I have a dataset of 430 fields, here is an excerpt :

I want to trim leading and trailing spaces from my field names. A simple transpose and then back to cross-tab does not work as I will lost all of my field names & vales. Help?

Thank you,

Courtney

[Bob_Blackey · Accepted solution]

You can use the Dynamic rename tool in the Developer tool set.

For rename mode choose - formula

Select all the fields you wish to rename (use the all button)

Then the Expression would be Trim([_CurrentFieldName_])

This tool can have two inputs but the bottom input is not needed in this use case.

[poles1c]

Thanks!