[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: RE: [sqr-users] double quotes in the sqr output (xls file)
- Subject: Re: RE: [sqr-users] double quotes in the sqr output (xls file)
- From: "Dietrich Schmitz" <schmitzd@upstate.edu>
- Date: Tue, 26 Nov 2002 19:01:08 -0500
- List-id: This list is for discussion about the SQR database reporting language from Brio Software. <sqr-users.sqrug.org>
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