Data Cleanse Column Headers

[cpomeroy]

Is there a way to cleanse my column headers?

[Luke_C]

@cpomeroy The dynamic rename tool might be what you're looking for, can you provide a bit more information?

[BrandonB]

I agree with @Luke_C that Dynamic Rename is the way to go. You can use formulas like trim([_CurrentField_]) to remove leading and trailing white spaces from column names or pretty much any other formula you would use to clean up data for that matter. 

[cpomeroy]

I have a column header that has a leading whitespace in it, and need to remove it for a formula that is being downstream in the process.

[mbarone]

As the others have said - dynamic rename is the way to go.

[YRichardson12]

Thank you, this worked!!!