Subject: RE: [xsl] FW: XSL to split a concatenated XML string From: "Michael Kay" <mike@xxxxxxxxxxxx> Date: Tue, 14 Mar 2006 11:19:02 -0000 |
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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] FW: XSL to split a concatenat, Cave, Neil | Thread | RE: [xsl] FW: XSL to split a concat, Cave, Neil |
[xsl] Mapping Values., Amal | Date | RE: [xsl] FW: XSL to split a concat, Cave, Neil |
Month |