#-*-encoding:utf-8-*-
#我用来提取全国邮政编码的,用的数据可以在CSDN下载
#比较简单,大家别砸我啊
#提取出来的数据压缩下放到我在Google AppEngine的小站了,地址是http://liuxin-blog.appspot.com/files/zip.rar.zip
#还算比较小,压缩起来还不到1M,有兴趣可以下载下来玩玩,用的HTML里的Table,也很容易提取到Excel和其他数据库
import string
def parserToHTML(line):
items = line[37:][:-3].split(",")
del items[0]
tds = [ "<td>" + str(item) + "</td>" for item in items]
s_td = string.join(tds, "")
tr = "<tr>" + s_td + "</tr>"
return(tr)
fileList = ["ZipCodeInsert01.SQL",
"ZipCodeInsert02.SQL",
"ZipCodeInsert03.SQL",
"ZipCodeInsert04.SQL"
]
zipFile = "zip.html"
counter = 0
for f in fileList:
lines = open(f, "r").readlines()
zipFileWriter = open(zipFile,'a')
for line in lines:
counter += 1
print(counter)
tr = parserToHTML(line)
zipFileWriter.write(tr + "/n")
zipFileWriter.close()
del lines
del zipFileWriter