Displaying ID for each multivalue

Hi
How to display ID for each mutivalue field.

>LIST FBNK.DATA V1 V2

ID V1 V2
..................................
83384 MY 3228
______KR 3220
______TH 4669
85250 TH 4669
______KR 1302
______MY 1127
______TW 1648

( Please ignore underline "_______" added to make columns align)

Here i want to display ID for each subvalue in output so that i can export it to excel and filter on basis V1="MY".

Or is there any way to select only those records which have "MY" in field V1 and correspoding V2 value. As noted above position of "MY" in V1 is not same and number of subvalues in V1,V2 is varying.

Thanks,
Ashish

Extracted from: "UniVerse Guide to RetrieVe"


Sorting Data with Multivalues

When you sort records on a multivalued field, you need to explode the values.
Although you could sort a multivalued field without exploding its values, the
output is usually not meaningful.
For example, assume that you want to list all scheduled vaccinations for the livestock,
in order by date, so that you can mark them on your calendar. Scheduled
dates are stored in the multivalued field VAC.NEXT, and the type of vaccination is
stored in an associated multivalued field called VAC.TYPE. Sorting on VAC.NEXT
without exploding it produces a list of records sorted by the first date found in
VAC.NEXT in each record, rather than by all dates, as shown:

>LIST LIVESTOCK.F DESCRIPTION VAC.NEXT VAC.TYPE ID.SUP
BY VAC.NEXT
LIST LIVESTOCK.F DESCRIPTION VAC.NEXT VAC.TYPE ID.SUP BY
VAC.NEXT 11:37:05AM 31 May 1995 PAGE 1
DESCRIPTION VAC.NEXT.. VAC.TYPE
Shetland 06/03/95 R
09/21/96 P
04/07/96 L
Horse 06/05/95 R
08/27/96 P
08/03/96 L
Horse 06/08/95 R
01/21/95 P
02/07/96 L
Linsang 06/12/95 R
03/27/95 P
03/30/95 L
Ferret 06/16/95 R

post you email so i can send you the manual.

Very easy with this tool:

eztier.com/web/?p=118

Read the section: "Selectively Exploding Fields"