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
________________________________ From: John McKown <joa...@swbell.net> To: IBM-MAIN@bama.ua.edu Sent: Friday, August 21, 2009 1:06:48 PM Subject: Re: Excel 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 DATA.I=VALUE END DATA.0=I /* PROCESS DATA */ END "EXECIO 0 DISKR INPUT(FINIS" -- John ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
