I figured it out,  [ SqlColumnNumber = 7 ] will rearrange the order of fields..

Does this matter if the routine is a object script routine? I have tried a lot of stuff and I keep getting various errors. 

Julius I tired your code but it's failing on the first line.

Any help would be appreciated 

Yea, I'll be updating a global with the data which I know how to do, just struggling to get the info from the file.

Thank you everyone for the suggestions! I have a lot to digest!  :)

I thought about that but I realized that not every entry is seperated by commas, some are 

MILFORD, OH 45150 

MILFORD OH 45150