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

[BobPerham]

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.

[LucasDanzinger]

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

[MathewCoyle]

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

[BobPerham]

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?

[LucasDanzinger · Accepted solution]

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