If your entire text file is set up the same way as your example, a quick
and dirty solution could be to open the text file in Excel, a dialog box
will open and you can set the column divisions and cell settings for the
columns in there (I tried it with your example and it was very
straightforward with no need to adjust the column width, only giving the
cells character settings).
That makes a standard excel file which you can copy and paste into a
Mapinfo browser after you create and give settings to a new TAB file.
Ie, you set up a new empty TABle in Mapinfo with the three* (four if you
want some kind of 'id' field) fields you require, then open the browser
which will, of course, be empty; make sure it's active and paste your
copied excel records directly into it.
I don't know Mapinfo's limit for records in one TABle offhand, but it
would just entail creating enough TABles to handle your data if you're
over the limit I assume.
HTH
Kurt Ackermann
Regional Science Institute
Sapporo, Japan
*I'm not sure whether the example you gave was 3 or 4 fields (columns),
but if it is 4 you could avoid the 3rd and 4th overlapping by doing a
global replace, for example of 5 spaces with 10. Again, it's a very
quick and dirty solution and anybody with even a smidgeon of Perl
experience will laugh at it, but it works if you're only semi-computer
literate, like me!
-Included Message--
Date: Wed, 30 Aug 2000 16:25:59 -0400
From: "Agen Greg SMSgt AFRC/RSOO" [EMAIL PROTECTED]
Reply-To: "Agen Greg SMSgt AFRC/RSOO" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: MI Importing a File
I have a "txt" file with over 300,000 records (One Record per line) in
it.
I want to import it into a MapInfo Table... what is the easiest way to
do
so?
Here is the Record Layout for each line
Position 1-2 Century
Position 3-6 Sep Year
Position 7 Filler
Position 8-9 Sep Month
Position 10-14 Zip Code
Position 15-19 FIPS Code
Position 20-21 State
Position 22-23 Service
Position 24-26 DOD OCC
Position 27-34 MOS
Position 35Count
GREGORY S. AGEN, SMSgt, USAF
NCOIC, HQ Recruiting Production Analysis
COM: (800) 223-1784 ext. 70147
DSN: 497-0147 DSN FAX: 497-0327
E-Mail: [EMAIL PROTECTED]
MOBILE: (478) 396-5011
MOBILE E-MAIL: [EMAIL PROTECTED]
PAGER: (800) 856-6122
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and
put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
-End of Included Message--
_
Tired of limited space on Yahoo and Hotmail?
Free 100 Meg email account available at http://www.dacafe.com
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
