bustersports
Programmer
I have downloaded the FedEx shipping zones from their website. They are based on zip codes, the 1st 3 digits. Example, a shipment going from 55531 to 85226 would be combined to be 555852 which would be a ship zone of 6. I have attached one of the files for you to look at. What I am looking for is a way to take all of the files, 708, be able to combine the zip code combinations and add the zone. The result would be a table that could be used for looking up the zone.
Here is what the data looks like to start. This is an example of shipments origination with zip codes 55300 - 55599, going to destination below. so 55530 going to 00500 would be combined into 553005, resulting in a zone of 6.
Destination Zip Zone
000-004 NA
5 6
010-011 6
12 5
013-051 6
52 5
53 6
54 5
55 6
56 5
057-067 6
068-083 5
84 6
What I would like to end up with, unless there is a better solution is:
Destination Zip Zone
000 NA
001 NA
002 NA
003 NA
004 NA
005 6
006 6
007 6
008 6
009 6
010 6
etc for all of the combinations. I hope this makes sense. Thanks for considering any options you are aware of.
FedEx does not offer the ability to download the files in any other format.
Here is what the data looks like to start. This is an example of shipments origination with zip codes 55300 - 55599, going to destination below. so 55530 going to 00500 would be combined into 553005, resulting in a zone of 6.
Destination Zip Zone
000-004 NA
5 6
010-011 6
12 5
013-051 6
52 5
53 6
54 5
55 6
56 5
057-067 6
068-083 5
84 6
What I would like to end up with, unless there is a better solution is:
Destination Zip Zone
000 NA
001 NA
002 NA
003 NA
004 NA
005 6
006 6
007 6
008 6
009 6
010 6
etc for all of the combinations. I hope this makes sense. Thanks for considering any options you are aware of.
FedEx does not offer the ability to download the files in any other format.