How to find Unicode 0x1a in big file?

[Former Member]

Hi,

I get an error in the message mapping:

   <SAP:P3>An invalid XML character (Unicode: 0x1a) was found</SAP:P3>

  <SAP:P4>in the element content of the document.</SAP:P4>

   The problem is that i read an 80.000 lines file from File adapter and map it to ECC.

   Unfortunately my SXMB_MONI does not tell me in which line the invalid XML character was found.    

   Before i tried with small files from same provider and there was never an issue in the mapping.  

   Is there an (easy) way to find what is the offensive character that PI cannot handle?

   Regards

   Robert

[former_member184720 · Accepted solution]

Download the payload from Moni and open the xml using Microsoft word document, it should tell you the location(line number and position)

[Former Member · Accepted solution]

Hi Hareesh,

Thx for reply.

Word complains that the file has unreadable content and refuses to open it.

Also it is about 80MB size.

Any other tricks we can use?

Regards

Robert

[Harish · Accepted solution]

Hi Robert,

I would suggest to try with notepad++.

regards,

Harish

[former_member184720 · Accepted solution]

If you expand that warning it should display the location details?

However if you have notepad++ then you try below approach..

java - How do I find (Unicode: 0x1) using notepad++ (unicode to char range) - Stack Overflow