This element is a sentence, formated as "CONFIRMATION XXX HAS BEEN CANCELLED", the "XXX" is a variable, including numbers and letters. I only want to get the "XXX" part. How can I do that?
The input XML file:
Code:
<?xml version="1.0" encoding="UTF-8"?>
<return>
<response1>CONFIRMATION 12345A HAS BEEN CANCELLED</response1>
<response2>CONFIRMATION B654321 HAS BEEN CANCELLED</response>
</return>
The output XML file should like:
Code:
<?xml version="1.0" encoding="UTF-8"?>
<return>
<r1>12345A</r1>
<r2>B654321</r2>
<return>
Using XSLT 1.0 version.
Thank you in advance.