6

Using the Field Calculator in ArcGIS 10.1, I am able convert the first letter in a value from lower case to upper case. How do you convert the entire value to upper case, though? I can't seem to locate a VBScript for it.

For example, I want to convert small to SMALL.

1
  • Use Python parser.
    – Tomek
    May 31 '13 at 13:57
18

Another alternative using Python would be:

!fieldname!.upper()

as described in the online help Calculate Field examples.

5
  • Why do they need to change the scripting where there is more room for errors. Why not just keep VBScripting for the latest Arc versions?
    – Zoran
    May 31 '13 at 15:26
  • 8
    +1 it would be best for everyone to wean themselves off vbscript and move onto python asap. May 31 '13 at 15:49
  • 1
    There is no mention of vbscript being deprecated in Desktop (yet), but if you read into the long term future of vbscript (on Desktop) based upon the ArcGIS Server deprecation plan, can it be too far off? ArcGIS 10.1 for Server no longer supports VBScript or JScript expressions on Linux. [...] Python scripting will be added as a replacement for these scripting languages and ArcGIS Desktop will support authoring Python scripts in areas where VBScript and JScript are presently used. May 31 '13 at 16:39
  • @RyanDalton -- The fact that Google is the best place to go to find this answer when I spent a good 30 minutes (At ESRI Technical Support)[support.esri.com/en/technical-article/000011159] trying to find this and only came up with the parallel answer !Existing Field!.title() -- Technically it may be Technical Support but practically it's just frustrating to use. -- But yes, thankfully they are moving on to Python and placing VB in the same bin as AML
    – user23715
    Jul 6 '18 at 22:20
  • In ArcGIS 10.6 the Python version was like this: [FIELDNAME].upper() to convert all lower cases to upper cases
    – maycca
    Feb 4 '21 at 10:01
9

You can use UCase

UCase( [fieldName] )

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.