This is a personal record of my python programming experiences. It will allow me to see how I am progressing as I learn a new language.
Thursday, August 16, 2012
Load address table into a database
import sqlite3
#Strips the unwanted text from address and stores it in a database.
cl=open("customerlist.txt")
con=sqlite3.connect("customer2.db")
cur=con.cursor()
for row in cl:
address=row
address.lstrip()
add1=address.split()
#print(add1[0:4])
cur.execute("CREATE TABLE IF NOT EXISTS cleantable(hsenumber text,dir text,street text, prefix text)")
cur.execute("INSERT INTO cleantable values(?,?,?,?)",add1[0:4])
con.commit()
Subscribe to:
Post Comments (Atom)
Followers
Blog Archive
- June (1)
- March (3)
- February (1)
- July (3)
- May (1)
- April (1)
- March (1)
- January (1)
- December (1)
- November (4)
- July (3)
- May (2)
- April (1)
- March (6)
- February (2)
- December (1)
- November (1)
- September (3)
- August (3)
- July (1)
- March (3)
- January (1)
- December (5)
- November (2)
- October (1)
- September (2)
- August (1)
- July (4)
- May (3)
- February (1)
- January (1)
- December (1)
- November (2)
- October (2)
- September (9)
- August (2)
- May (1)
- April (1)
- March (6)
- February (5)
- January (3)
- August (2)
No comments:
Post a Comment