[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: FW: XSL to split a concatenated XML string
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: 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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|