MQSeries.net :: View topic - Wanted help in parsing TDS to XML

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Wanted help in parsing TDS to XML

Wanted help in parsing TDS to XML

« View previous topic :: View next topic »

Author

Message

sree4vit

Posted: Tue Aug 10, 2010 3:38 am Post subject: Wanted help in parsing TDS to XML

Novice

Joined: 05 Aug 2010
Posts: 21

Input:

<A>
<B>
1234#abcde#bbbbb#ccccc
</B>
</A>

Output expected:

<X>1234</X>
<Y>abcde</Y>
<Z>bbbbb</Z>
<W>ccccc</W>

Here i have built a message set for <X><Y><Z><W> and defined # as delimitter.

But Since my input is a combination of XML and TDS i'm not able to parse properly.

My <X> will take entire <A><B>1234 as its value and similarly the <W> will take ccccc</B></A>.

Any hints on fixing this?

Thanks in advance.

mqjeff

Posted: Tue Aug 10, 2010 4:39 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Use XMLNSC to deal with the XML.

Use TDS to deal with the TDS data extracted from the XML.

No shortcuts.

kimbert

Posted: Thu Aug 12, 2010 12:54 am Post subject:

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Use something like this:

Code:

CREATE LASTCHILD OF OutputRoot.XMLNSC.xxx PARSE InputRoot.XMLNSC.parent.child.xxxx DOMAIN 'MRM' SET 'myMessageSetName' TYPE 'myDelimitedMessageType' Format 'TDS1'

The syntax is probably wrong, but hopefully you can see how it works.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Wanted help in parsing TDS to XML

Jump to:

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

Protected by Anti-Spam ACP