I understand that, you require to extract the last multi value of a MV-set. *Y.DICT* = 30]25]42]50 Here u r trying to extract *'50'* The best way is Y.DICT.CNT = DCOUNT(Y.DICT,@VM) Y.LAST.MV = *Y.DICT*<1,Y.DICT.CNT> Then the variable Y.LAST.MV pertains the value *'50'*
Regards, Abi... On 5/5/09, inavran <[email protected]> wrote: > > > Hi, > > I was wondering if anyone knew the correct syntax for extracting the > 'last multi-value' from a field using a 10 line dictionary items > > eg record (3 attributes with 4 multi-values on each line) > > 001:john]dave]simon]chris > 002:blue]red]yellow]green > 003:30]25]42]50 > > i would want to extract just "chris" from attribute 1. (being the last > MV) > > also, i would be curious how to extract a specific other multi value > as well (eg "dave" (MV 2) > > at present i am doing this using a subroutine CALL within the DICT, > which is very slow (as you would expect), so i am keen to get a better > solution in place. > > I am using jBASE 3.4.x on Windows 2003 > > Many thanks in advance. > > Ian > > > > --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
