inHandler = open(inFile, 'r')
outHandler = open(outFile, 'w')
outHandler.write('ID\tAddress\tStreetNum&Name\tSufType\tDir\tCity\tProvince\tPostalCode\n')
for line in inHandler:
str = line.replace('FarmID\tAddress','')
outHandler.write(str[0:-1])
str = str.replace(', ON', '\t ON\t')
> I don't have any code to split that part up. There is other information
> following the street name such as street suffix, city, province, postal code,
> etc. I have been able to split the rest of it up based on certain criteria
> but have had no luck with splitting up the street name from th
I have the following sample from a data set and I am looking to split the
address number and name into separate headings as seen below.
FarmID Address
1 1067 Niagara Stone
2 4260 Mountainview
3 25 Hunter
4 1091 Hutchinson
5 5172 Green Lane
6 500 Glenridge
7
