Unwanted Spaces and Iterative Loop

[matt.s.marotta at gmail.com]

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.