[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
SQR Issue - Can I read a Excel Flat File into SQR Variables?
- Subject: SQR Issue - Can I read a Excel Flat File into SQR Variables?
- From: John Cox <John_Cox@PEOPLESOFT.COM>
- Date: Fri, 8 Jan 1999 15:12:46 -0800
Hello All, I have a SQR problem for all you guru's out there. I am
trying to read in an excel flat file (saved as a .CSV) and read that into
SQR variables. The problem is that some of the variables contain commas...
Here's a row from my flat file (.CSV) file
JOB,ACCT_CD,Account Code,"paydes,209","Defines a link between the
distribution of an employee's earnings to funding from a grant, loan, etc."
I want to store this row into these variables into my SQR program
$RecName
$Fieldname
$LongName
$Source
$Descr
The problem is that Excel puts quotes around the columns with a comma in
them. Does anyone know a way to code this so I can
open this file and read these elements into variables? Every row has a
different length of Recname, Fieldname, etc.
Thanks for any info...
-jc