| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Replace Diacritic with non-diacritic characters |
« View previous topic :: View next topic » |
| Author |
Message
|
| pascalzelen |
 Posted: Fri Jan 16, 2009 3:36 am Post subject: Replace Diacritic with non-diacritic characters |
 |
|
Newbie
Joined: 16 Jan 2009
Posts: 3
|
Hi there,
I have to build a Message Broker flow that reads an xml message from a queue and replaces the diacritic characters in the message with non-diacritic ones (so replace é with e, ö with o, etcetera).What's the easiest way to do this? Hope someone can help me with this.
Regards,
Pascal |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Fri Jan 16, 2009 3:51 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
You could create a char set map that allows for that kind of mapping say from char set 1200 to whatever you define and then back....
So with one cast you eliminate the diatric chars and with the cast back you have your text in the original without the diatric chars. Or create some kind of java function that does that for you as well... Might be easier to handle as a Java function... Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| pascalzelen |
| Posted: Fri Jan 16, 2009 5:08 am Post subject: |
|
|
Newbie
Joined: 16 Jan 2009
Posts: 3
|
| Thanks for your answer, but how and where can I define such a character set map? Is it like creating your own CCSID and then do something (in ESQL) like: CAST(InputRoot.XMLNSC AS CHARACTER CCSID ...)? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Jan 16, 2009 5:22 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
No, don't do that.
Just use OVERLAY or whichever of the other String functions is the right one for this situation. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
