[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: JOHN_HARRIS@qvc.com
- Date: Tue, 21 Feb 2006 10:43:22 -0500
- Delivery-date: Tue, 21 Feb 2006 10:49:10 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Yes it would, typo on my part. But I think that is what she wants to
print.
Thank you.
Regards,
John
(Embedded image moved John Harris
to file: Programmer/Analyst
pic25547.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.
|---------+----------------------------------------------->
| | "Brian Turner" |
| | <briturne@fastenal.com> |
| | Ext: |
| | Sent by: |
| | sqr-users-bounces+john_harris=qvc.co|
| | m@sqrug.org |
| | |
| | |
| | 02/21/2006 10:32 AM |
| | Please respond to "This list is for |
| | discussion about the SQR database |
| | reporting language from Hyperion |
| | Solutions." |
| | |
|---------+----------------------------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: "This list is for discussion about the SQR database
reporting language from Hyperion Solutions." |
| <sqr-users@sqrug.org>
|
| cc: (bcc: JOHN HARRIS/QVC)
|
| Subject: RE: [sqr-users] Writing a single quote in a string
|
>------------------------------------------------------------------------------------------------------------------------------|
Wouldn't your xxx value print out as '3207368' 10001 'HRAF'?
-----Original Message-----
From: sqr-users-bounces+briturne=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+briturne=fastenal.com@sqrug.org] On Behalf Of
JOHN_HARRIS@qvc.com
Sent: Tuesday, February 21, 2006 9:23 AM
To: This list is for discussion about the SQR database reporting
language from 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
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
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