Look at BY.EXP. It returns a select list of "keys" separated by @FMs,
each "key" being "@ID @VM FIELD.VALUE". You'll need to manipulate it
yourself converting @VMs to *s if that's the way you want it.

Cheers,
Wol

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Marco Manyevere
Sent: 26 March 2004 06:33
To: [EMAIL PROTECTED]
Subject: How to sort a file by multivalue field?

How can I SELECT  a file by a multivalue field and return a list of
@ID:"*":FIELD.VALUE in sorted order of FIELD.VALUE?
 
E.g:
 
record A = 800:@VM:600:@VM:700
record B = 400:@VM:900:@VM:1000:@VM:300
record C = 650:@VM:200
 
I want the output as follows:
 
C*200
B*300
B*400
A*600
C*650
A*700
A*800
B*900
B*1000
 
Thanks for any help.
Marco

                
---------------------------------
  Yahoo! Messenger - Communicate instantly..."Ping" your friends today!
Download Messenger Now
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users




***********************************************************************************

This transmission is intended for the named recipient only. It may contain private and 
confidential information. If this has come to you in error you must not act on 
anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, 
or show it to anyone. Please e-mail the sender to inform us of the transmission error 
or telephone ECA International immediately and delete the e-mail from your information 
system.

Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong 
Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333.

***********************************************************************************

--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Reply via email to