RE: [sqr-users] double quotes in the sqr output (xls file)

["Beller, Jay" <jbeller@lbisoftware.com>]

You can try in-line as follows (example of the ="quoted value" format):

                write 1 from $fmt_Level ',="' $Keyval '","' $Rec_Descr '",' 
$Level_Indent $Filename ',' $fmt_Records

Or, first declare the variables for different csv output:

!       For csv output

        let $Delim = ','
        let $Quote = '"'
        let $EqQuote = '="'
        let $QuoteDelim = '",'

THEN, reference the variables in you output statement:

!       Write out the data

                write 1 from $Delim $Ctrl_Desc $Delim
                        $EqQuote $Ctrl_Tax_State    $QuoteDelim
                        $EqQuote $Ctrl_Tax_Locality $QuoteDelim
                        $EqQuote $Ctrl_Tax_Class    $QuoteDelim
                        $EqQuote $Ctrl_Tax_Resident $QuoteDelim
                        $Delim $Delim $Test_Desc $Delim
                        $EqQuote $Test_Tax_State    $QuoteDelim
                        $EqQuote $Test_Tax_Locality $QuoteDelim
                        $EqQuote $Test_Tax_Class    $QuoteDelim
                        $EqQuote $Test_Tax_Resident $QuoteDelim
                        $fmt_Test_Tax_Amt $Delim $fmt_Test_Tax_Gross 
-----Original Message-----
From: Ven Garlapati [mailto:VXG@creditacceptance.com]
Sent: Tuesday, November 26, 2002 12:33 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] double quotes in the sqr output (xls file)


Hi All:

I have a sqr program, which produces output in xls file format.  For the 
headings part of it, I need to use " (double quotes), for instance, if the 
column heading is AVERAGE BB WHOLESALE AVERAGE, it should appear like - AVERAGE 
"BB WHOLESALE AVERAGE" (bb wholesale average in the double quotes). 

I have tried the following combinations in vain, I think double quotes have 
some other meaning in sqr, which I am not aware.
I have also looked into couple of books and could not find relevant information.

'"BB Wholesale Average"'
'"'||'BB Wholesale Average'||'"'        

Any suggestion would be helpful.

Thanks,
Ven Garlapati 


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users