Stupid ETL app has a job that exports a SQL query in XML file with the following format:
<?xml version="1.0" encoding="UTF-8"?>
<Export>
<Record>
<Property Name="Name">XMLProperties</Property>
<Property Name="Value" PreFormatted="1"><?xml version='1.0' encoding='UTF-16'?><Properties version='1.1'><SQL><SelectStatement modified='1' type='string'><![CDATA[select 'query' from dual]]></SelectStatement></SQL></Properties ></Property>
</Record>
</Export>
I'd like to extract the SQL string but I can't figure out how to use XSL to extract an XML with different encoding inside another XML.