FW: [sqr-users] Writing a single quote in a string

["Griffith, Peggy" <Peggy.Griffith@sappi.com>]

Thanks, these are all good answers.

-----Original Message-----
From: sqr-users-bounces+peggy.griffith=sappi.com@sqrug.org
[mailto:sqr-users-bounces+peggy.griffith=sappi.com@sqrug.org] On Behalf
Of JOHN_HARRIS@qvc.com
Sent: Tuesday, February 21, 2006 10:23 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] Writing a single quote in a string

Try
LET $QUOTE = '''
let xxx = $QUOTE||'3207368'||$QUOTE||' 10001 '||$QUOTE|| 'HRAF'||$QUOTE

This will produce the following, when xxx is printed: '3207368 10001
HRAF'

                                                              
                                                              
 Thank you.                                                   
                                                              
 Regards,                                                     
                                                              
 John                                                         
                                                              
                                                              
                                                              
 (Embedded image moved    John Harris                         
 to file:                 Programmer/Analyst                  
 pic09576.jpg)            Application Development - Internal  
                                                              





QVC Inc., 1200 Wilson Drive, MC 220, West Chester, PA 19380-4262


Telephone 484-701-3303
Fax 484-701-8689
e-mail jharris@qvc.com



This message may contain information that is privileged or confidential.
This message may contain information that is privileged or confidential.
If
you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein is STRICTLY PROHIBITED. If you received this transmission in
error,
please immediately contact the sender and destroy the material in its
entirety, whether in electronic or hard copy format.


|---------+----------------------------------------------->
|         |           "Griffith, Peggy"                   |
|         |           <Peggy.Griffith@sappi.com>          |
|         |           Ext:                                |
|         |           Sent by:                            |
|         |           sqr-users-bounces+john_harris=qvc.co|
|         |           m@sqrug.org                         |
|         |                                               |
|         |                                               |
|         |           02/21/2006 10:10 AM                 |
|         |           Please respond to "This list is for |
|         |           discussion about the SQR database   |
|         |           reporting  language from Hyperion   |
|         |           Solutions."                         |
|         |                                               |
|---------+----------------------------------------------->
 
>-----------------------------------------------------------------------
-------------------------------------------------------|
  |
|
  |       To:       <sqr-users@sqrug.org>
|
  |       cc:       (bcc: JOHN HARRIS/QVC)
|
  |       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


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.

Here was a non admissible message part of 'image/jpeg' MIME type. It
has been automatically discarded before sending the message to the
list. 
_______________________________________________
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