On Mar 19, 2009, at 9:32 PM, Stockly, Ed wrote: >>>> I believe that Ed uses Excel. Ed, you could import a tab or > comma-delimited text file > > I do, but this isn't for me, it's a script used by someone else... > > > >>> Mark Reed>>Well, sure. If you don't mind having a massive list in >>> memory, you > can make it even faster: > > What OSAX are you using to get "position"? > > Plus, yours doesn't handle the zips that lie outside the ranges > > For Example.... > >>> Mark Lively>>One problem, 06390 is in New York. > > Drat. > > The source page I was using had this for New York: > (ZIP >= 90 && ZIP <= 149) || (ZIP == 4) || (ZIP == 63) > > Which is correct, but it had this for Connecticut: > ZIP >= 60 && ZIP <= 69 > > Which is not correct. (Nice catch, Mark). > Not mine when I was looking for a list I saw something that said one little town in new york has a connecticut zipcode and is server by a connecticut post office. You could special case that one out.