🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: net.micro.pc
Article #6434

Re: LOTUS QUESTION

#6434
From: Jeffrey T. Jones
Date: Mon, 05 May 1986 15:22
17 lines
1485 bytes
In article <3474@gatech.CSNET> andrew@gatech.CSNET (Andrew Ditchfield) writes:
>I am importing an ASCII file that is in a table format.  The problem is that
>the whole table is assigned to column 'A' of the spreadsheet.  After several
>records a table record is encountered which is too big to read into one
>column of Lotus.
>Any advice on how to map the fields in my table like ASCII file to the 
>columns in Lotus ??

Try using the /FIN (file - import - numbers) instead of /FIT (text).  I use
this all the time and it works Ok.  The only thing that bugs me is that I lose
all the text.  However, the numbers are what's important to me, and they work
fine.  Hope this helps...
-- 
Any opinions expressed are my own, and have NO connection with my employer.
--
Jeffrey T. Jones              jtjones@nosc.ARPA
(619) 225-7815                {ihnp4,decvax,ucbvax}!sdcsvax!noscvax!jtjones
Technical Details
Message-ID: <141@tetra.UUCP>
Path: arc1-ca.pugleaf.net!utzoo!linus!philabs!cmcl2!harvard!husc6!panda!genrad!decvax!ittatc!dcdwest!sdcsvax!noscvax!tetra!jtjones
References: <3474@gatech.CSNET>

Show Full Headers
Complete Article Headers
Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP
Path: arc1-ca.pugleaf.net!utzoo!linus!philabs!cmcl2!harvard!husc6!panda!genrad!decvax!ittatc!dcdwest!sdcsvax!noscvax!tetra!jtjones
From: jtjones@tetra.UUCP (Jeffrey T. Jones)
Newsgroups: net.micro.pc
Subject: Re: LOTUS QUESTION
Message-ID: <141@tetra.UUCP>
Date: Mon, 5-May-86 11:22:29 EDT
Article-I.D.: tetra.141
Posted: Mon May  5 11:22:29 1986
Date-Received: Thu, 8-May-86 08:26:54 EDT
References: <3474@gatech.CSNET>
Reply-To: jtjones@tetra.UUCP (Jeffrey T. Jones)
Organization: Naval Ocean Systems Center, San Diego
Lines: 17