import csv, re, sqlite3 con = sqlite3.connect("database2.db") cur = con.cursor() f = open("region_init", "w+") toWrite = '' for i in range(0, 1373): cur.execute("Select region from region where ug like "+str(i)) result = cur.fetchall() if(result == []): toWrite = "Null\n" else: toWrite = str(result[0]).replace(')','').replace('(','').replace('\'','') toWrite = toWrite[:-1]+"\n" f.write(toWrite)