Does anyone know how to construct an f-type correlative that will
extract the second value of an mv field without using the translate
(e.g., (TPROD;X2;10;10) function? I am creating an index file and need
this as a x-type dictionary item - mvEnterprise flavor.

Thanks,

Dave

Try this:

A; IF 10:NV = 10:'2' THEN 10 ELSE '' should work, does not on uv 10
or
F;10;'1';NV;'2';=;'999';*;[] works on uv 10

both should return mv2 or nulls for others. this may not work index if it
indexes nulls, but there may be an option to ignore them like NO.NULLS in
uv.

*But by far the better way would be to store the required value in another
attribute!*

Chandru

<morrtech (AT) comcast (DOT) net> wrote

Chandru,

Thanks for your response...I'll let you know if it works.

Dave

Chandru,

It works perfectly! Thank you very much...please let me know if I can
ever return the favor.

Dave Morrison