topic Re: Changing the case of text field values in Data Management Questions

Changing the case of text field values

KevinCrosby — Mon, 25 Jun 2012 19:21:10 GMT

the arcgis help page gives the Python script of

' '.join([i.capitalize() for i in !FieldName!.split(' ')])

to change the text values of an attirbute from YAY PYTHON, yay python, YaY pYtHoN, etc to Yay Python

but when i copy and paste this into GIS and replacing FieldName with the correct field name, it give me a geoprocessing error.

any ideas on how to correctly get this to format my fields?

ArcGIS 10

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Changing_the_case_of_text_field_values/005s00000028000000/

Re: Changing the case of text field values

MarcinGasior — Tue, 26 Jun 2012 05:29:13 GMT

What error exactly do you get?
The code is OK so you might missed something when typing or your data is specific.

Alternatively you can try another Python function which basicaly do the same:
!FieldName!.title()

Re: Changing the case of text field values

KevinCrosby — Tue, 26 Jun 2012 15:01:00 GMT

"A field name was no found or there were unbalanced quotation marks"

a couple entrys have special characters like () in them...might that be causing the issue?

Re: Changing the case of text field values

MarcinGasior — Wed, 27 Jun 2012 04:10:05 GMT

This error indicates that you have something wrong in expression.
Double check if you provide existing field name (not a field alias) enclosed with ! !

() should not be a problem to run expression - just if a separate word is enclosed with (), it won't be capitalised.

Re: Changing the case of text field values

KevinCrosby — Wed, 27 Jun 2012 12:30:53 GMT

Figured out the problem. There were a couple entries with words in "" in them that seemed to ruin the script. Removed the "" surrounding the words and it started working perfectly