Jump to content

 
Photo

Changing text Case in ArcMap

- - - - -

  • Please log in to reply
7 replies to this topic

#1
ELeFevre

ELeFevre

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 1,050 posts
  • Gender:Male
  • Location:Louisville, Colorado USA
  • Interests:Cartography, Music, GIS, Coffee
  • United States

Does anyone know the function (or have a VB script) for changing all uppercase text, i.e "COLORADO" to "Colorado" in ArcMap. I can't find it in the ArcMap Help.



#2
benbakelaar

benbakelaar

    Ultimate Contributor

  • Associate Admin
  • PipPipPipPipPipPip
  • 658 posts
  • Gender:Male
  • Location:North Brunswick, NJ
  • Interests:maps, information, technology, scripting, computers
  • United States

Does anyone know the function (or have a VB script) for changing all uppercase text, i.e "COLORADO" to "Colorado" in ArcMap. I can't find it in the ArcMap Help.

<{POST_SNAPBACK}>


Here's a thread about changing your attribute table cells...
http://forums.esri.c...&t=98549#275079

but I think you are referring to user-added text boxes?

#3
ELeFevre

ELeFevre

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 1,050 posts
  • Gender:Male
  • Location:Louisville, Colorado USA
  • Interests:Cartography, Music, GIS, Coffee
  • United States

Thanks for the link, Ben. I'll check out the tips and let you know how it works out.

"User added text boxes"...I'm not sure I understand?

Basically I have a column with 1,600 records, all upper-case and most of the attributes are comprised of two or more words, i.e, SALT LAKE CITY. E



#4
ELeFevre

ELeFevre

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 1,050 posts
  • Gender:Male
  • Location:Louisville, Colorado USA
  • Interests:Cartography, Music, GIS, Coffee
  • United States

This works:

StrConv ( [YOUR FIELD],vbProperCase )



#5
benbakelaar

benbakelaar

    Ultimate Contributor

  • Associate Admin
  • PipPipPipPipPipPip
  • 658 posts
  • Gender:Male
  • Location:North Brunswick, NJ
  • Interests:maps, information, technology, scripting, computers
  • United States

"User added text boxes"...I'm not sure I understand?

<{POST_SNAPBACK}>


Since you didn't say "text from a table" I thought you might mean like work you had done in layout view, like hand labeling places. I guess that's mostly the non-Esri people who end up needing to do that, for whatever reason.

#6
MapMedia

MapMedia

    Hall of Fame

  • Validated Member
  • PipPipPipPipPipPipPip
  • 1,029 posts
  • Gender:Male
  • Location:Davis, California
  • United States

You don't need a script - there is an option in text proporties (not sure which tab as I am remote from workstation) - but it gives you options Sentence case, lower, upper, super, etc.

Nice for working with databases that are all caps.

Chris

#7
ELeFevre

ELeFevre

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 1,050 posts
  • Gender:Male
  • Location:Louisville, Colorado USA
  • Interests:Cartography, Music, GIS, Coffee
  • United States

Chris,
Even though the script I posted did the trick, it would great if I could do it as you have suggested. Would you mind posting a little more info on how to do this when you get the chance? Erin.



#8
mike

mike

    Legendary Contributor

  • Validated Member
  • PipPipPipPipPip
  • 320 posts
  • Gender:Male
  • Location:Toronto, ON
  • Canada

You don't need a script - there is an option in text proporties (not sure which tab as I am remote from workstation) - but it gives you options Sentence case, lower, upper, super, etc.

Nice for working with databases that are all caps.

Chris

<{POST_SNAPBACK}>


You're right, there is a text option to change caps, but that only works to convert to All Caps or Small Caps or normal. so if you had all lower case, you can change to all caps or small caps. but if your original text is all caps already, there is no option to change to initial caps unfortunately. However, the script posted above works great.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

-->