[xsl] FW: XSL to split a concatenated XML string

Subject: [xsl] FW: XSL to split a concatenated XML string
From: "Cave, Neil" <Neil.Cave@xxxxxxxxxxxxxx>
Date: Tue, 14 Mar 2006 11:34:43 +0100
Hi XSL Ninjas

I have to split a list of concatenated XML strings and display it in 2
fields

The xml looks like

<?xml version="1.0" encoding="UTF-8" ?>
<optionList1>
<option>T51000000000000000000000000    NONE,.</option>
<option>T51000000000010000000000000    31 VAN STRAAT,.</option>
<option>T51000000000020000000000000    29 VAN   STRAAT,.</option>
<option>T51000000000030000000000000    36 BECKERWEG,.</option>
<option>T51000000000040000000000000    34 BECKERWEG,.</option>
</optionList1>

And I need to display 2 distinct columns  (in HTML)....

Stand Number                   Address

T51000000000000000000000000    NONE,.
T51000000000010000000000000    31 VAN STRAAT,.
T51000000000020000000000000    29 VAN   STRAAT,.
T51000000000030000000000000    36 BECKERWEG,.
T51000000000040000000000000    34 BECKERWEG,.

There will always be 14 occurrences of option within optionList1 the
stand number will always be 27 characters followed by space.

What's the best way to tackle this?

Regards
Neil

Current Thread