topic Re: Field values returned in unicode in Python Questions

Field values returned in unicode

Zeke — Wed, 16 Jul 2014 13:19:03 GMT

In the code below, the field values are returned in unicode (e.g. (u' 06510',)). How do I get this to return ascii, as in 06510,? Thanks. Hopefully doing this right, new forums confusing.

with arcpy.da.SearchCursor(fc, "OLDPLATE") as rows:

for row in rows:

if row is None or len(row) == 0: lstNullOldPlates.append("Null or empty")

else: lstAllOldPlates.append('{0}'.format(row))

Re: Field values returned in unicode

RobertScheitlin__GISP — Wed, 16 Jul 2014 13:34:14 GMT

Greg,

You should always add a tag to your post in the new forums (i.e. Python) so that the python people can find your discussion and better yet start your discussion in the python space Python‌

Robert

Re: Field values returned in unicode

IanMurray — Wed, 16 Jul 2014 13:45:57 GMT

you need to call the ord() method on it and it should convert your unicode string to ascii.

2. Built-in Functions — Python v2.7.8 documentation‌

Re: Field values returned in unicode

DonOpgenorth — Wed, 16 Jul 2014 13:59:51 GMT

I've
moved your post into the Python space. You will get a much
better answer here as the GeoNet Help is intended for community
help and feedback. I have also added in a few additional tags. You can see more
on the community structure, and what topics are under each space from the
following documents:

GeoNet Community Structure

ArcGIS Discussion Forums Migration Strategy

Thanks!

Don

Re: Field values returned in unicode

Zeke — Wed, 16 Jul 2014 15:33:53 GMT

Thanks all. I searched for a python oriented forum, couldn't find it. This new format will really take some getting used to.

Re: Field values returned in unicode

Zeke — Wed, 16 Jul 2014 19:42:14 GMT

Thanks Ian, but ord didn't work. The values are test, a mix of letters, blanks and numbers. Ord() works on one at a time, and gave me a TypeError when I tried parsing the values.

I did manage to fix the problem though. I'd forgotten that arcpy.da returns a tuple, not the (in this case) text value. When I added row[0] to the processing instead of just row, it worked as desired. Thanks everyone. I hesitate to mark my own answer as correct, don't want to violate protocol, but on the other hand that might be useful to others.

Re: Field values returned in unicode

IanMurray — Wed, 16 Jul 2014 19:51:07 GMT

Ah, well I'm glad you got it worked out.

Re: Field values returned in unicode

curtvprice — Thu, 17 Jul 2014 18:00:24 GMT

What is your use case that requires you to convert unicode? Normal ascii characters should always be treated the same whether they are unicode or not.

Python treats unicode and text pretty much the same if the content doesn't contain any international characters. In Python 3.4 there is no distinction. The only way you can tell it is unicode is when it is rendered by repr(), for example when you enter the variable at the command line.