[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?



   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