G'day,
I have data given to me in an excel spreadsheet. Is there any way that I
can move this data from my PC and MS excel to a sequential file that I can
edit with ISPF editor?
I've tried a saving as a text file (everything is jammed together on a
line). Same thing with a CSV file.
I've tried
Stocker, Herman wrote:
G'day,
I have data given to me in an excel spreadsheet. Is there any way that I
can move this data from my PC and MS excel to a sequential file that I can
edit with ISPF editor?
I've tried a saving as a text file (everything is jammed together on a
line). Same thing
On Fri, 21 Aug 2009 11:16:02 -0400, Stocker, Herman wrote:
I have data given to me in an excel spreadsheet. Is there any way that I
can move this data from my PC and MS excel to a sequential file that I can
edit with ISPF editor?
In order to process some Excel data with a script, I opened it
Thank you Steve.
Regards,
Herman Stocker
-Original Message-
From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf
Of Steve Comstock
Sent: Friday, August 21, 2009 11:27 AM
To: IBM-MAIN@bama.ua.edu
Subject: Re: Excel to DSORG=PS conversion
Stocker, Herman wrote
The way I do this is to take excel and put it into a table in WORD. Then
convert the word doc to a format I want on the MF and then save as a TXT file.
Then up load to the minframe.
If you have NSF/DSF in place or can use the ISPF WS Client, then you could edit
the txt file on your PC using
On 21 Aug 2009 08:39:00 -0700, paulgboul...@aim.com (Paul Gilmartin)
wrote:
I have data given to me in an excel spreadsheet. Is there any way that I
can move this data from my PC and MS excel to a sequential file that I can
edit with ISPF editor?
In order to process some Excel data with a
On Fri, 21 Aug 2009 10:42:51 -0600, howard.bra...@cusys.edu wrote:
I have been using delimited files, read in and parsed by programs.
But then I discovered that I can save an Excel document as a .PRN
document. This is probably what you want to do.
Oh, one trouble with this method is that the
Parsing a CSV file in REXX should be very simple. Something along the lines of:
/* REXX */
DO FOREVER
EXECIO 1 DISKR INPUT
IF RC 0 THEN LEAVE
PARSE PULL RECORD
I=0
DO WHILE RECORD
PARSE VAR RECORD VALUE ',' RECORD
I=I+1
DATA.I=VALUE
to DSORG=PS conversion
Parsing a CSV file in REXX should be very simple. Something along the lines of:
/* REXX */
DO FOREVER
EXECIO 1 DISKR INPUT
IF RC 0 THEN LEAVE
PARSE PULL RECORD
I=0
DO WHILE RECORD
PARSE VAR RECORD VALUE ',' RECORD
I=I+1
So what happens if your data in a cell contains a comma? Do you have to
account for that possibility in REXX?
Lizette
Parsing a CSV file in REXX should be very simple. Something along the lines of:
/* REXX */
DO FOREVER
EXECIO 1 DISKR INPUT
IF RC 0 THEN LEAVE
PARSE PULL
On Fri, 21 Aug 2009 10:18:15 -0700, Scott Ford scott_j_f...@yahoo.com wrote:
I agree with John this have done with SAS csv files ..with no problem at
all in Rexx ( the wonder horse ), pretty easy .
Scott J Ford
Silly me. I forgot to say it is also simple in awk and Perl as well.
Perl
while()
-Original Message-
From: IBM Mainframe Discussion List
[mailto:ibm-m...@bama.ua.edu] On Behalf Of Lizette Koehler
Sent: Friday, August 21, 2009 12:25 PM
To: IBM-MAIN@bama.ua.edu
Subject: Re: Excel to DSORG=PS conversion
So what happens if your data in a cell contains a comma? Do
Thank you Lizette. I never though of a word table.
Regards,
Herman Stocker
-Original Message-
From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf
Of Lizette Koehler
Sent: Friday, August 21, 2009 12:24 PM
To: IBM-MAIN@bama.ua.edu
Subject: Re: Excel to DSORG=PS
On Fri, 21 Aug 2009 12:06:48 -0500, John McKown wrote:
Parsing a CSV file in REXX should be very simple. Something along the lines of:
/* REXX */
DO FOREVER
EXECIO 1 DISKR INPUT
IF RC 0 THEN LEAVE
PARSE PULL RECORD
I=0
DO WHILE RECORD
PARSE VAR RECORD VALUE
Must admit I was stunned you didn't offer this as an option first.
John Mc wrote:
Silly me. I forgot to say it is also simple in awk and Perl as well.
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send
15 matches
Mail list logo