Field Names Too Long - how to count field name characters

[brendafos]

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.

[MarqueeCrew]

@brendafos ,

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

[CharlieS · Accepted solution]

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!

[brendafos]

Thank you.  This is exactly what I needed.  

Alteryx is just wow for things like this....

Now if Alteryx only allowed you to search for fields in the Select (and similar) tools.