Re: SQR Issue - Can I read a Excel Flat File into SQR Variables?

[Greg Gargett <ggargett@SEANET.COM>]

i've written a csv parsing sqc if you're interested.

John Cox wrote:

>    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



--
Greg

"I never have more than one drink before dinner.
But I do like that one to be large and very strong
and very cold and very well-made." - Ian Fleming