cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with input data format - not "only" XML

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi Buddy

What is the XI adapter using?

If you use inbound File adapter content conversion you could replace these values with none and then pass it to the scenario.

Does that help?

Regards

cK