Article View: net.micro.pc
Article #6447Re: LOTUS QUESTION
From: Wallis
Date: Wed, 07 May 1986 14:22
Date: Wed, 07 May 1986 14:22
21 lines
1403 bytes
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!snafuReferences:
<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