I need to automatically optimize text field character length to their current largest attribute character count. For example the field "MyName" is 250 characters long, but has attributes that are a maximum 6 characters long, the field "MyName" character length needs to updated from 250 characters to 6 characters.
I can do this processes manually (with possible errors), but I need a faster more reliable method to give to ArcGIS users. Before I start to write an ArcPy tool, has anymore written something like this before?
I'm guessing the ArcPy method would loop through each text field (A) and then loop through each row and note the largest attribute length (B), then it would pass the field name (A) and character length (B) to the output.