Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP Path: 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 > >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