Why restrict yourself to 10 line DICTionary items ? Try the additional features provided by I types
DICT file mv2_of_Attr1 Last_mv_of_Attr1 mvcnt mv2_of_Attr1 001 I 002 @RECORD<1,2> 003 004 2nd Value in Attribute 1 005 10L Last_mv_of_Attr1 001 I 002 FIELD(1,@VM,mvcnt) 003 004 Last value in Attribute 1 005 10L mvcnt 001 I 002 COUNT(1,@VM)+1 003 004 Number of values in Attribute 1 005 5R LIST file mv2_of_Attr1 Last_mv_of_Attr1 should give you : 'dave' and 'chris' respectively, based on your data below, Pat. On 5 May, 11:13, 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 -~----------~----~----~----~------~----~------~--~---
