RE: How to sort a file by multivalue field?

2004-03-26 Thread Anthony Youngman 
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

Re: How to sort a file by multivalue field?

2004-03-25 Thread Results 
Marco,
   Create a DICT item like this:
   000 U2_1
   001 A
   002 1
   009 R
   010 10
   And one like this:

   000 U2_2
   001 A
   002 0
   008 F;0R;"*";1;:;:
   009 L
   010 10
Then you can type this:
 
   SORT MV BY-EXP U2_1 U2_2
  

--
Sincerely,
 Charles Barouch
 www.KeyAlly.com
 [EMAIL PROTECTED]


Marco Manyevere wrote:

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