From owner-freebsd-questions Fri Mar 31 08:18:27 1995 Return-Path: questions-owner Received: (from majordom@localhost) by freefall.cdrom.com (8.6.10/8.6.6) id IAA25436 for questions-outgoing; Fri, 31 Mar 1995 08:18:27 -0800 Received: from cs.weber.edu (cs.weber.edu [137.190.16.16]) by freefall.cdrom.com (8.6.10/8.6.6) with SMTP id IAA25426 for ; Fri, 31 Mar 1995 08:18:25 -0800 Received: by cs.weber.edu (4.1/SMI-4.1.1) id AA03829; Fri, 31 Mar 95 09:12:05 MST From: terry@cs.weber.edu (Terry Lambert) Message-Id: <9503311612.AA03829@cs.weber.edu> Subject: Re: your mail To: acarlson@tigger.jvnc.net Date: Fri, 31 Mar 95 9:12:05 MST Cc: questions@FreeBSD.org In-Reply-To: <199503141858.AA09440@relay.interserv.com> from "acarlson@tigger.jvnc.net" at Mar 14, 95 10:58:21 am X-Mailer: ELM [version 2.4dev PL52] Sender: questions-owner@FreeBSD.org Precedence: bulk > I am new to the internet and am having "troubles". I have a windows 3.1 pc > w/5mb RAM and use a full service carrier for my access to the net. Today I > downloaded a file from > freebsd.cdrom.com /.11/freeBSD/freeBSD-cu/src/share/misc zipcodes (825574 > bytes) > The reason I got the file was to be able to look up places when just knowing > the zip code. After I downloaded the file I got the file "zipcodes" with no > extension and although I can scroll through it by using "type zipcodes" in > MS-DOS I can't figure out how to get this data into a database or someway I > can use all the data. When I tried to load it into my Lotus Approach db > program, I got a note saying the file was encrypted. Any help would be > appreciated. Rename the file zipcodes.txt; it's a simple text file. Lotus Approach determines if a file is encrypted by looking at its extension and contents; if this persists after you rename the file, insert some text at the top of the file using a text editor; something like "Stupid software, this is a plain file" should be enough to throw it off (it's probably the word "code" that's doing you in). A CDROM with more recent information is available from the US Postal services; I believe it is reasonably priced, and that the data is stored in CSV (comma seperated value) format, ideal for import into a database. You should be aware that a full zip+4 database takes in excess of 60 9 track tapes (on the order of 2G of disk space uncompressed) as delivered by the USPS as of 5 years ago. Terry Lambert terry@cs.weber.edu --- Any opinions in this posting are my own and not those of my present or previous employers.