Re: DCOUNT in DICT, Which Correlative?

[Charlie Noah]

002 COUNT(@RECORD<1>, ',') 002 COUNT(@RECORD<3>, @VM) counts the number of commas and value marks, respectively 002 IF @RECORD<1> # '' THEN COUNT(@RECORD<1>, ',') + '1' ELSE '0' 002 IF @RECORD<3> # '' THEN COUNT(@RECORD<3>, @VM) + '1' ELSE '0' counts the number of comma and value mark delimited values (even if the values are null), respectively Charlie Noah On 07-19-2011 3:55 PM, pat wrote: Try : DICT file comma_count 001 I 002 COUNT(f1,',') 003 004 Commas in Attr1 005 10R DICT file f1 001 D 002 1 003 004 Attr1 005 10L DICT file vm_count 001 I 002 COUNT(f3,',') 003 004 VM's in Attr3 005 10R DICT file f3 001 D 002 1 003 004 Attr3 005 10L On Jul 19, 3:10 pm, inavran <inav...@gmail.com> wrote: Hi, Does anyone know the equivalent correlative or command for what would be DCOUNT()  in DATABASIC, in a DICT. eg. 1) I would like to count how many commas "," there are in attribute 1 2) I would like to count how many @VMs there are in attribute 3 Im assuming its the same command for both of the above. I was playing with Corr type A,  NV, but that lists a rolling count of the value markers and explodes them out. Any suggestions would be helpful. many thanks 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 jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en