how to change a field in all caps to a new field in proper case
Here is the way to do this in Excel:
https://www.groovypost.com/howto/convert-text-uppercase-lowercase-capitalize-excel-2016/
Expression: ' '.join([i.capitalize() for i in !STATE_NAME!.split(' ')]) Expression Type: PYTHON_9.3
Expression: string.capwords(!STATE_NAME!, ' ') Expression Type: PYTHON_9.3 Code Block: import string
Expression: MySub(!STATE_NAME!) Expression Type: PYTHON_9.3 Code Block: def MySub(myfieldname): import string return string.capwords(myfieldname, ' ')