How to use the 'GROUP' keyword

Hi, Can anyone explain the usage of the GROUP keyword in jbasic programming.

www.jbase.com/knowledgebase/manuals/3.0/...s/man/jbc2_GROUP.htm

this link will answer your question.

regards,
saravanan

Thanks Saravanan,

I tried this command without specifying the last parameter (expression 4 - no of fields to extract as a group). It does not work. In my case the no of fields will vary to one another. Do you have any idea abt it.

Hi,

You need to do the following right?

Y.VAR1 = GROUP(ARRAY,@FM,1,N)

here can be vary.. you update the value of N by what ever way you want.


regards,
saravanan

the link is broken

www.jbase.com/r5/knowledgebase/manuals/3...s/man/jbc2_GROUP.htm

Check the following from manual

GROUP( )
The GROUP function is an extension of the FIELD function allowing the return of a group of fields rather than
just a single one.
Command Syntax
GROUP(Expression1, Expression2, Expression3, Expression4)
Syntax Elements
Expression1 evaluates to the string containing fields to be extracted. Expression2 evaluates to the character(s)
delimiting each field within Expression1. Expression3 should evaluate to a numeric value specifying the number
of the first field to extract from Expression1. Expression4 evaluates to a numeric value specifying the number of
fields to extract as a group.
Notes
Expression2 may evaluate to more than a single character allowing fields to be delimited with complex
expressions.
Examples
A = "123:-456:-789:-987:-"
CRT GROUP(A, ":-", 2, 2)
This example will display
456:-789
on the terminal being the second and third fields and their delimiter within variable A.