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

[Ray Ontko <rayo@ONTKO.COM>]

JC,

Take a look at:

   http://www.ontko.com/sqr/csv.html

You'll find a free collection of SQR procedures to help manipulate
CSV files, along with example programs.  You should be able to
use them to solve your problem.

Ray

On Fri, Jan 08, 1999 at 03:12:46PM -0800, 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
----------------------------------------------------------------------
Ray Ontko       |  Ray Ontko & Co  |  "Time for a new signature line."
rayo@ontko.com  |  Richmond, In    |  See us at http://www.ontko.com/