[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Writing a single quote in a string
- Subject: RE: [sqr-users] Writing a single quote in a string
- From: "Bob Stone" <bstone@fastenal.com>
- Date: Tue, 21 Feb 2006 09:32:00 -0600
- Delivery-date: Tue, 21 Feb 2006 10:38:11 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AcY2+QD/ZTakDOA0Q9aUT2b/AiI6xgAAd5Qg
- Thread-topic: [sqr-users] Writing a single quote in a string
to print a single string or assign a single string within a variable,
you use 2 single quotes in a row. Now, it gets a tad confusing if you
have one right at the beginning or if you want it to be a quote by
itself, because it's next to the single quote characters that are
delimiting your string.
let $mystring = 'there is a quote '' <-there'
let $mystring = '''this starts with a quote'
let $mystring = 'notice the 3 quotes in a row mean 2 to show a quote,
1 for the end of string '''
let $mystring = 'I am concatting' || '''' || 'a single quote in the
middle'
Don't confuse the single quotes that are the outsides of your strings
with those that are the trying to produce a single quote, and it's
pretty easy.
-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of
Griffith, Peggy
Sent: Tuesday, February 21, 2006 9:11 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Writing a single quote in a string
Hi - my SQR is writing a text file and I need to include a single quote
as part of a string; does anyone know how to do that?
Example:
let xxx = ''3207368'10001 'HRAF'
(after the first single quote there is supposed to be a single quote,
and then within the string there are 2 other single quotes as well as a
space).
I have been told to try using the single quote within single quotes
which does not work, also told to try 4 single quotes before the string
but that does not work.
Peggy Griffith
Business Systems Analyst
Sappi Fine Paper North America
179 John Roberts Road
South Portland, Maine 04016
Tel: 207.854.7466
This message may contain information which is private, privileged or
confidential and is intended solely for the use of the individual or
entity named in the message. If you are not the intended recipient of
this message, please notify the sender thereof and destroy / delete the
message. Neither the sender nor Sappi Limited (including its
subsidiaries and associated companies) shall incur any liability
resulting directly or indirectly from accessing any of the attached
files which may contain a virus or the like.
_______________________________________________
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