On Sunday, 26 January 2014 18:44:16 UTC-5, Jason Friedman wrote: > outHandler.write("FarmID\tAddress\tStreetNum\tStreetName\tSufType\tDir\tCity\tProvince\tPostalCode") > > > > ... > > FarmID Address > > 1 1067 Niagara Stone Rd, Niagara-On-The-Lake, ON L0S 1J0 > > 2 4260 Mountainview Rd, Lincoln, ON L0R 1B2 > > 3 25 Hunter Rd, Grimsby, ON L3M 4A3 > > 4 1091 Hutchinson Rd, Haldimand, ON N0A 1K0 > > > You are wanting to produce tab-separated output, with an "Address" field > plus the Address split into fields for Street Number, Street Name, Suffix > Type, Direction? > > > > The four lines you have pasted are examples of your input? If yes, > "Direction" is a single letter?
Yes to your first question. Yes, the four lines I have pasted are examples of input. Direction is a single letter (there are some records that are `King St. E,`). I have solved the problem with the spaces, but still cannot figure out the iterative loop to get rid of the farm ID in the address column that isn`t split. -- https://mail.python.org/mailman/listinfo/python-list