topic Re: How do I apply Title Case to just a portion of a text field in Python Questions

How do I apply Title Case to just a portion of a text field

BobPerham — Thu, 14 Mar 2013 21:29:08 GMT

I have an address field in all caps and I want to convert just the city to title case. So I currently have:

AKRON, OH 12345
BREA, CA 54321

And I want to see:

Akron, OH 12345
Brea, CA 54321

Basically I want to know how to convert just a portion of a string, in this case the portion before the comma.

Re: How do I apply Title Case to just a portion of a text field

LucasDanzinger — Sat, 11 Dec 2021 23:47:33 GMT

There could be a more elegant way, but this should do the trick:

>>> a = 'AKRON, OH 12345'
>>> alist = a.split(",")
>>> city = alist[0].title()
>>> final = city + "," + alist[1]
>>> print final
Akron, OH 12345

Re: How do I apply Title Case to just a portion of a text field

MathewCoyle — Sat, 11 Dec 2021 23:47:36 GMT

Lucas has it right I'd say, I'd maybe do something like this. Essentially the same thing.

line = 'AKRON, OH 12345'
line_split = line.split(',')
final_line = '{0},{1}'.format(line_split[0].title(), line_split[1])
print final_line

Re: How do I apply Title Case to just a portion of a text field

BobPerham — Thu, 14 Mar 2013 22:32:29 GMT

I'm sorry. Maybe I should have mentioned, I need to do this in the field calculator. The field name is CITYSTATE. So normally I would just enter !CITYSTATE!.title() and it would Title Case the whole value. Do I need to check off "Show Codeblock" and add it as pre-script logic?

Re: How do I apply Title Case to just a portion of a text field

LucasDanzinger — Thu, 14 Mar 2013 22:56:31 GMT

You can integrate either of these into the field calculator. Select to use Python for the parser, and check to Show Codeblock.

Expression should be:

title(!fieldName!)

Code Block:

def title(name):   alist = name.split(",")   city = alist[0].title()   final = city + "," + alist[1]   return final