| Author |
Message
|
| harshvajra |
 Posted: Fri Aug 10, 2007 1:41 am Post subject: set OutputRoot.MsgFormat.Element1 = char with apostrophe... |
 |
|
Apprentice
Joined: 23 Apr 2007
Posts: 46
Location: India
|
Hello all,
I have a small problem setting with apostrophe in a character.
The requirement is :
Set OutputRoot.XML.Element1.Element2 = 'quarter's'.
we need an apostrophe in the string,
i don't know how to go about this.
Would any one help me do this.
Thanks in advance.
_________________
Failure is not a defeat,it's just a delay, Walk TALL |
|
| Back to top |
|
 |
| AkankshA |
| Posted: Fri Aug 10, 2007 2:03 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
Set OutputRoot.XML.Element1.Element2 = 'quarter'''s'.
_________________
Cheers |
|
| Back to top |
|
|
| AkankshA |
| Posted: Fri Aug 10, 2007 2:23 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
Set OutputRoot.XML.Element1.Element2 = 'quarter' ||''''||'s'
_________________
Cheers |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Fri Aug 10, 2007 2:25 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi,
Hmmm, was it...
| AkankshA wrote: |
| Set OutputRoot.XML.Element1.Element2 = 'quarter'''s'. |
or
| Code: |
| Set OutputRoot.XML.Element1.Element2 = 'quarter''s'. |
Regards. |
|
| Back to top |
|
|
| harshvajra |
| Posted: Fri Aug 10, 2007 2:44 am Post subject: |
|
|
Apprentice
Joined: 23 Apr 2007
Posts: 46
Location: India
|
Hello all,
Thankyou for your help.
I've got the required by 2 ways.
One with two double quotes i.e
* Set OutputRoot.XML.Element1.Element2 = 'quarter''s' *
is working rather than
* Set OutputRoot.XML.Element1.Element2 = 'quarter'''s'. *
and
the other way i've got it through use of XML.AsIsElementContent.
* Set OutputRoot.XML.Element1.(XML.AsisElementContent) = 'quarter''s';
but the concatination dosent seem to work
* Set OutputRoot.XML.Element1.Element2 = 'quarter' ||''''||'s' *.
Thankyou.
_________________
Failure is not a defeat,it's just a delay, Walk TALL |
|
| Back to top |
|
|
| AkankshA |
| Posted: Fri Aug 10, 2007 2:51 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
typo error its Set OutputRoot.XML.Element1.Element2 = 'quarter''s'
_________________
Cheers |
|
| Back to top |
|
|
| vsr |
| Posted: Fri Aug 10, 2007 6:55 am Post subject: Re: set OutputRoot.MsgFormat.Element1 = char with apostrophe |
|
|
Centurion
Joined: 04 Apr 2006
Posts: 104
|
| harshvajra wrote: |
Hello all,
Set OutputRoot.XML.Element1.Element2 = 'quarter's'.
|
Try using LIKE escape character '\' (backslash) before apostrophe and let us know
| Quote: |
| Set OutputRoot.XML.Element1.Element2 = 'quarter\'s'. |
|
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Aug 10, 2007 9:00 am Post subject: Re: set OutputRoot.MsgFormat.Element1 = char with apostrophe |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| vsr wrote: |
| Try using LIKE escape character '\' (backslash) before apostrophe and let us know |
Maybe you should try it yourself first, before suggesting it.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| vsr |
| Posted: Fri Aug 10, 2007 1:12 pm Post subject: Re: set OutputRoot.MsgFormat.Element1 = char with apostrophe |
|
|
Centurion
Joined: 04 Apr 2006
Posts: 104
|
| jefflowrey wrote: |
| vsr wrote: |
| Try using LIKE escape character '\' (backslash) before apostrophe and let us know |
Maybe you should try it yourself first, before suggesting it. |
Jeff, that's correct! You are the Master ! I am sorry for the wrong response.
Anyway, I came across these links when searching in the net:
http://www.xml.com/pub/a/2003/02/26/qa.html
http://www.xml.com/pub/a/2001/01/31/qanda.html
I guess possible solution can be using entity reference or CDATA |
|
| Back to top |
|
|
| shalabh1976 |
| Posted: Sun Aug 12, 2007 10:09 pm Post subject: |
|
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
As far as I know in ESQL Single quote ' is the escape char and not \.
You have posted the links as you saw them on a xml site. This is MB.
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate |
|
| Back to top |
|
|
|
|
