tokenize(), grouping problem

Play the video

Subject: tokenize(), grouping problem
From: Jon Crump <jjcrump@xxxxxxxxxxxxxxxx>
Date: Fri, 22 Apr 2005 15:07:48 -0700 (PDT)

Once again, I know I'm missing something obvious. Could somebody wiser put me out of my misery?

If I have xml:

<data>
	<record>
		<subjects>subj1; subj2; subj3</subjects>
	</record>
	<record>
		<subjects>subj4; subj1; subj5</subjects>
	</record>
	<record>
		<subjects>subj3; subj6; subj5</subjects>
	</record>
</data>

and wish to obtain result:

<data>
	<subject>subj1</subject>
	<subject>subj2</subject>
	<subject>subj3</subject>
	<subject>subj4</subject>
	<subject>subj5</subject>
	<subject>subj6</subject>
</data>

I can use tokenize() to split the strings at the semicolon, but how can I then use the result in a for-each-group group-by procedure to output the unique values?

__________
J.J. Crump
Dept. of History 353560
University of Washington
Seattle, WA. 98195

Current Thread
Stumbling with xxx:node-set (where xxx is MS of MSXML4) Karl Stubsjoen - 22 Apr 2005 15:40:39 -0000 Jon Crump - 22 Apr 2005 22:08:10 -0000 <= David Carlisle - 22 Apr 2005 22:18:17 -0000 Bruce D'Arcus - 22 Apr 2005 22:24:00 -0000

<- Previous	Index	Next ->
Stumbling with xxx:node-set (, Karl Stubsjoen	Thread	Re: tokenize(), grouping prob, David Carlisle
Stumbling with xxx:node-set (, Karl Stubsjoen	Date	Re: tokenize(), grouping prob, David Carlisle
	Month

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

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >