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

["Michael Kay" <mike@xxxxxxxxxxxx>]

The substring() function does this pretty directly.

Michael Kay
http://www.saxonica.com/ 

> -----Original Message-----
> From: Cave, Neil [mailto:Neil.Cave@xxxxxxxxxxxxxx] 
> Sent: 14 March 2006 10:35
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject: [xsl] FW: XSL to split a concatenated XML string
> 
> 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