topic Re: How to label mixed cases when the data originally in all caps? in Mapping Questions

How to label mixed cases when the data originally in all caps?

EmilyLee — Thu, 10 Mar 2016 19:04:17 GMT

Hello,

Is there a way to label features in Mixed Cases when the data originally in all CAPS?

Original attribute table:

Currently, under Label Expression, I have:

"DISTRICT "& [DISTRICT] & vbnewline & [SUPERVISOR]

But I would like the label to look like this:

Any idea please?

Thank you very much!

Emily

Re: How to label mixed cases when the data originally in all caps?

DarrenWiens2 — Thu, 10 Mar 2016 19:07:00 GMT

In the Label Expression, change the Parser to Python, and use the expression [Name].title() - if your field is called "Name".

Re: How to label mixed cases when the data originally in all caps?

RichardFairhurst — Thu, 10 Mar 2016 20:03:59 GMT

Darren:

I am sure you meant to use exclamation marks for the field delimiters with the Python Parser and not brackets, which are used with the VB Parser. So if the field is called "Name", the expression should instead be:

!Name!.title()

Capitalization will happen only for the first character at the beginning of the field and for the first alpha character that follows any white space, numbers, punctuation or special characters. So you have to check for things like numbered streets which will appear as "1St Street" to make it "1st Street". Also, no alpha characters of a word other than the first one will be capitalized, so you have to check for things like Scottish last names beginning with Mc to change "Mcdonald" to "McDonald". Also it capitalizes all words, including small words that normally are not capitalized in book titles like "a", "an", and "the".

Re: How to label mixed cases when the data originally in all caps?

DarrenWiens2 — Thu, 10 Mar 2016 20:17:38 GMT

No, the label expression dialog does it differently than the field calculator (convenient...). !Name!.title() results in an error.

Re: How to label mixed cases when the data originally in all caps?

RichardFairhurst — Thu, 10 Mar 2016 20:22:06 GMT

You are correct. I never do this with the label expression and only use the field calculator since I always want to correct the items I noted in my amended response, but a label expression works for the data in this case.

Re: How to label mixed cases when the data originally in all caps?

EmilyLee — Wed, 16 Mar 2016 15:44:27 GMT

Thank you both Darren and Rich!