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

["Dietrich Schmitz" <schmitzd@upstate.edu>]

Assuming you are first 'open'ing a text file, try:
write 1 from - 
 '"column heading 1",' -
 '"column heading 2",' -
.
.
.
 '"last column heading"'

After writing out the headings, for each row of data:
write 1 from -
 '"' $data_elem_1 '",' -
 '"' $data_elem_2 '",' -
.
.
.
 '"' $last_data_elem '"'

Does this help?

Dietrich T. Schmitz
SUNY Upstate Medical University
schmitzd@upstate.edu
>>> VXG@creditacceptance.com 11/26/02 16:55 PM >>>
I have tried below option, sorry, did not work. I am seding here a partial
code ... to make it more clear, what I am saying below:


Thanks,
Ven Garlapati 
vxg@creditacceptance.com
(248) 353-2700 ext.514


-----Original Message-----
From: Merritt, Bruce [mailto:Merritt@uscolo.edu]
Sent: Tuesday, November 26, 2002 2:08 PM
To: 'sqr-users@sqrug.org'
Subject: RE: [sqr-users] double quotes in the sqr output (xls file)


Replace the '"' with chr(34)

Bruce Merritt, MSCS 
IT Professional
University of Southern Colorado


-----Original Message-----
From: Ven Garlapati [mailto:VXG@creditacceptance.com]
Sent: Tuesday, November 26, 2002 10:33 AM
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

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