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
    Commented May 31, 2013 at 13:57

2 Answers 2

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
    Commented May 31, 2013 at 15:26
  • 8
    +1 it would be best for everyone to wean themselves off vbscript and move onto python asap. Commented May 31, 2013 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. Commented May 31, 2013 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
    Commented Jul 6, 2018 at 22:20
  • In ArcGIS 10.6 the Python version was like this: [FIELDNAME].upper() to convert all lower cases to upper cases
    – maycca
    Commented Feb 4, 2021 at 10:01
9

You can use UCase

UCase( [fieldName] )

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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