🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: net.micro.pc
Article #6447

Re: LOTUS QUESTION

#6447
From: Wallis
Date: Wed, 07 May 1986 14:22
21 lines
1403 bytes
> >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...

Using the /FIT option will preserve text if it is
enclosed in double-quotes (e.g., "text" ).


--
                              Dave Wallis
                           ihnp4!ihlpm!snafu
                       AT&T Network Systems, Inc.
                            (312) 510-6238
Technical Details
Message-ID: <801@ihlpm.UUCP>
Path: arc1-ca.pugleaf.net!utzoo!watmath!clyde!burl!ulysses!mhuxr!mhuxn!ihnp4!ihlpm!snafu
References: <3474@gatech.CSNET> <141@tetra.UUCP>

Show Full Headers
Complete Article Headers
Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP
Path: arc1-ca.pugleaf.net!utzoo!watmath!clyde!burl!ulysses!mhuxr!mhuxn!ihnp4!ihlpm!snafu
From: snafu@ihlpm.UUCP (Wallis)
Newsgroups: net.micro.pc
Subject: Re: LOTUS QUESTION
Message-ID: <801@ihlpm.UUCP>
Date: Wed, 7-May-86 10:22:10 EDT
Article-I.D.: ihlpm.801
Posted: Wed May  7 10:22:10 1986
Date-Received: Fri, 9-May-86 09:54:27 EDT
References: <3474@gatech.CSNET> <141@tetra.UUCP>
Organization: AT&T Bell Laboratories
Lines: 21