Skip to Content
0
Former Member
Nov 25, 2008 at 01:20 AM

Problem with input data format - not "only" XML

52 Views

Hi Experts,

I have problem with input data format.

I get some data from JMS ( MQSeries) , but input format is not clear XML.

This is some like flat file with content of XMLu2026.

Example:

0000084202008-11-0511:37<?xml version="1.0" encoding="UTF-8"?>
<Document xmlns="urn:xsd:test.01" xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance Sndr="0001" Rcvr="SP">
...content....
</Document>000016750

Problems in this file is :

1. data before parser <? xml version="1.0"> -> 0000084202008-11-0511:37

2. data after last parser </Document> -> 000016750

This data destroy XML format.

Unfortunately XI is not one receiver of this files and we canu2019t change this file format in queue MQSeries ( before go to XI) .

My goal is to get XML from this file:

<?xml version="1.0" encoding="UTF-8"?>
<Document xmlns="urn:xsd:test.01" xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance Sndr="0001" Rcvr="SP">
...content....
</Document>

My questions:

1. Is any way or technique to delete this data 0000084202008-11-0511:37 in XI from this file ?

2. Is any way to get only XML from this file ?

Thanx .

Regards,

Seo