Field Names Too Long - how to count field name characters

I'm outputing data to a .tde and Tableau has a max field name character count 128 -

There are hundreds of fields, so I need to find which field names are too long, so I can change them.

How can I count the characters in a field NAMEs - not the values in the fields, the field NAMES/TITLES

Then can I do a bit of find and replace to fix this?

Since many of the names are similar I'd like to do a global rename, or something efficient like that.

Here is a small sample of the field names I'm dealing with.

long field NAMES.JPG

Parse

Accepted answers

I put together an example of how the Find Replace and Dynamic Rename tools can be used to apply some global name replacements.

I hope this helps!

Use a field info tool and then put a formula to calculate the Length() of the field name. This is NOT the exact formula, just a hint.

cheers,

Mark

I put together an example of how the Find Replace and Dynamic Rename tools can be used to apply some global name replacements.

I hope this helps!