This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
distinct moves problem
- From: Ahmad J Reeves <ahmad at dcs dot qmul dot ac dot uk>
- To: xsl list <XSL-List at lists dot mulberrytech dot com>
- Date: Mon, 07 Jan 2002 14:04:25 +0000
- Subject: [xsl] distinct moves problem
- Organization: Dept of Computer Science, QMW
- Reply-to: xsl-list at lists dot mulberrytech dot com
Hi all,
Just wanted to say thanks once again for helping
questions. This is the best list I've seen for
genral helpfulness and good things!
Just a quick question, with the same data..
<LOG>
<DIRECT>
<COMMUNICATION_TYPE> PAGETELL </COMMUNICATION_TYPE>
<Invoc_serial> 27 </Invoc_serial>
<Serial> 3087908 </Serial>
<USAGE> TELL </USAGE>
<MESSAGE_TYPE> EMOTE </MESSAGE_TYPE>
<CHARACTER_ID> 10010 </CHARACTER_ID>
<CHARACTER_STATUS> 3 </CHARACTER_STATUS>
<LOCATION_ID> 45040 </LOCATION_ID>
<TARGET_CHARACTER_ID> 444444 </TARGET_CHARACTER_ID>
<TARGET_CHARACTER_STATUS> 6 </TARGET_CHARACTER_STATUS>
<TARGET_CHARACTER_LOCATION_ID> 23222
</TARGET_CHARACTER_LOCATION_ID>
<MESSAGE>hello</MESSAGE>
<TIME> 'Mon, 26 Nov 2001 15:40:29 +0000' </TIME>
</DIRECT>
etc etc 50,000 or so times
</LOG>
I also need to track the movement of a character. So
for example I know that a certain character_id has
been in say 25 rooms of which 9 were unique, but
I cant see how I can work out the number of distinct moves he makes
using xsl.
So I can get output like this:-
Ch-ID in-room Message Target-ID time
23470 45040 Hello 12345 10:19
23470 43333 Hi 23432 10:23
23470 45040 Yo 43333 10:44
etc..
etc..
This tells me he was in a total of three rooms of which
2 were unique AND he has made 2 MOVES so far. So I need
to work out the total number of distinct moves per character-ID,
with a total and average for all of them.
Any help gratfully received,
Cheers
Ahmad
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list