topic Re: æøå and python in Geoprocessing Questions

æøå and python

MortenTranekjaer — Fri, 09 Jul 2010 07:59:25 GMT

Hi,

I'm struggling with a small python script. What I want is that the script should export all selected attributes from at select by location operation (on two feature layers) to a text file. The script works fine when attribute data doesn't contain æøå, but when æøå is in it only returns (write to txt file)those attributes (road names) from the top in which æøå is not a part of det text string. To me it seems as if the cursor stop when it bumps into æøå. I'm sure it's a matter of encoding, but i don't know how to solve this? 😞

Does anyone know how to solve this issue? Here is the code (it is the field "VEJNAVN" that contains æøå):

******
import sys, arcgisscripting, string
gp = arcgisscripting.create(9.3)

ADRESSER = sys.argv[1]
gp.overwriteoutput = 1
try:
    logfile = "C:\\Documents and Settings\cg21mj\\Skrivebord\\logfile.txt"
    log = open(logfile, "w")
    log.write ("OBJECTID"+";"+"KOMMUNENR"+";"+"VEJNAVN"+";"+"VEJKODE"+";"+"HUSNUMMER"+";"+"NKLASSE"+";"+"TSTAND\n")
    rows = gp.SearchCursor(ADRESSER)
    row = rows.Next()
    while row <> "":
        result0 = row.GetValue("OBJECTID")
        result1 = row.GetValue("KOMMUNENR")
        result2 = row.GetValue("VEJNAVN")
        result3 = row.GetValue("VEJKODE")
        result4 = row.GetValue("HUSNUMMER")
        result5 = row.GetValue("NKLASSE")
        result6 = row.GetValue("TSTAND")
        log.write(str(result0) + ";" + str(result1) + ";" + str(result2) + ";" + str(result3) + ";" + st(result 4) + ";" + str(result5) + ";" + str(result6) + "\n")
        row = rows.Next()
    log.close()
except:
    print gp.GetMessages()

*****

Thanks in advance!

Regards,
Morten
GIS coordinator, Denmark

Re: æøå and python

GünterDörffel — Sat, 11 Dec 2021 14:38:36 GMT

Hi Morten,

python is sensible in special characters ... we have them a lot in germany, too 🙂

Try adding a starting line to your python script telling it to work in unicode:

 
# -*- coding: utf-8 -*-

This LOOKS like a comment AND NEEDS TO BE THE FIRST LINE OF THE SCRIPT ... but it is important!
You might want to use a different codepage ... or even go further and use the python concepts of
.encode() and .decode() ... but usually declaring the codepage to work in will do!

Regards
Guenter

Re: æøå and python

MortenTranekjaer — Fri, 09 Jul 2010 09:47:52 GMT

Hi Guenter,

Thanks for your very quick reply 🙂

I already tried the utf-8 codepage yesterday, but it doesn't work, hmm! I will give it a try with the .encode() and .decode concept.

Best regards,
Morten

Re: æøå and python

MortenTranekjaer — Mon, 12 Jul 2010 07:59:08 GMT

Hi Guenter,

I found a quick and easy solution!

I just added the following lines to the scritpt and VOILA it works 😄

reload(sys)
sys.setdefaultencoding('utf-8')

Regards,
Morten

Re: æøå and python

GünterDörffel — Tue, 13 Jul 2010 02:32:56 GMT

Hi Morten,

I'll add that to my troubleshoot-list ... thanks and glad it works now!

Regards
Guenter

Re: æøå and python

Luke_Pinner — Wed, 14 Jul 2010 02:30:14 GMT

If you ever want to distribute your code, you're better off explicitly using encode/decode.

"sys.setdefaultencoding is evil"
http://aspn.activestate.com/ASPN/Mail/Message/python-dev/3744296