I have an excel sheet of about 6500 zipcodes. Example: GREEN BAY WI 54344 GREEN BAY WI 54308 GREEN BAY WI 54307 GREEN BAY WI 54305 GREEN BAY WI 54301 GREEN BAY WI 54304 GREEN BAY WI 54302 GREEN BAY WI 54303 GREEN BAY WI 54306 HIGH POINT NC 27265 HIGH POINT NC 27264 HIGH POINT NC 27263 HIGH POINT NC 27262 HIGH POINT NC 27261 HIGH POINT NC 27260 PALM BAY FL 32910 PALM BAY FL 32909 PALM BAY FL 32908 PALM BAY FL 32907 PALM BAY FL 32906 PALM BAY FL 32905 PALM BAY FL 32911 I need to trim down the list, so I want to remove some entries that are close together. If the first 3 numbers of a zipcode are the same, I want to remove all but 1 zipcode. so new list would be like: GREEN BAY WI 54344 HIGH POINT NC 27265 PALM BAY FL 32910 there are 6000 entries...so probably need to use a program.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
xls or csv