>Received: from VM.MARIST.EDU by vnet.IBM.COM (IBM VM SMTP V2R3) with TCP;
>   Mon, 04 Dec 95 11:39:58 EST
>Received: from VM.MARIST.EDU by VM.MARIST.EDU (IBM VM SMTP V2R3)
>   with BSMTP id 7966; Mon, 04 Dec 95 11:34:17 EST
>Received: from VM.MARIST.EDU (NJE origin LISTSERV@MARIST) by VM.MARIST.EDU
> (LMail V1.2a/1.8a) with BSMTP id 9640; Mon, 4 Dec 1995 11:34:13 -0500
>Received: from VM.MARIST.EDU by VM.MARIST.EDU (LISTSERV release 1.8b) with NJE
>          id 5153 for ADSM-L AT VM.MARIST DOT EDU; Mon, 4 Dec 1995 11:34:09 
> -0500
>Received: from MARIST (NJE origin SMTP@MARIST) by VM.MARIST.EDU (LMail
>          V1.2a/1.8a) with BSMTP id 9608; Mon, 4 Dec 1995 11:33:52 -0500
>Received: from protein3-pc.rockefeller.edu by VM.MARIST.EDU (IBM VM SMTP V2R3)
>          with TCP; Mon, 04 Dec 95 11:33:51 EST
>Received: by protein3-pc.rockefeller.edu (IBM OS/2 SENDMAIL VERSION
>          1.3.14/2.12um) id AA0053; Mon, 04 Dec 95 11:36:14 -0800
>Mime-Version: 1.0
>X-Mailer: Ultimedia Mail/2 Lite, IBM T. J. Watson Research Center
>Content-Id: <40_89_1_818094774>
>Content-Type: text/plain; charset="US-ASCII"
>Content-Transfer-Encoding: 7bit
>Message-ID:  <9512041936.AA0053 AT protein3-pc.rockefeller DOT edu>
>Date:         Mon, 4 Dec 1995 11:34:09 -0500
>Reply-To:     matherj AT rockvax.rockefeller DOT edu
>Sender:       "Dist. Stor. Manager(ADSM) List" <ADSM-L AT VM.MARIST DOT EDU>
>From:         Jeffrey Mathers <matherj AT ROCKVAX.ROCKEFELLER DOT EDU>
>Subject:      Accounting records (2nd posting)
>To:           Multiple recipients of list ADSM-L <ADSM-L AT VM.MARIST DOT EDU>

>ATTN ADSM Development/Support Staff:

>On page 216 of the ADSM/2 Administrator's Guide a statement is made that
>the accounting record file can be "easily" read into Lotus 1-2-3 for OS/2.
>I don't know how to read in a comma delimited string containing a mixture
>of text and number fields so that each field is placed in a separate cell.

>Can someone help me with how to do this? I have considerable expereince
>with 1-2-3 for OS/2, yet I do not know how to perform the necessary tasks,
>i.e. parsing a string with a separator.
>
>Regards,
>
>Jeffrey C. Mathers
>Computer Data Systems Manager
>The Protein/DNA Technology Center
>The Rockefeller University

Jeffrey;     Lotus requires a " to identify text in mixed format (text and
          numerical data).
             I ran into this situation a while back and resolved it by
          writing a REXX program to parse the comma delimited data and
          inserting a " in the text fields.

             For example:

             input:  01,090,TEXT,300  = output: 01,090,"TEXT",300

             I then did an Lotus import and everything ended up in the right
          spot.

             The REXX exec is very simple minded and "fine tuned" for the
          particular function I was doing. I can send to you if you want to
          see it.

                                                                  Steve