Welcome to jBASE's new documentation site! Many answers to your questions can be found by searching the Knowledgebase or viewing the jBASE Documentation. We also have a Google Group for peer discussion about jBASE. If you are unable to find the information you are looking for, jBASE Support will be glad to assist in resolving your technical problems. Enjoy and please provide comments and feedback .

How can we help you?

GROUP

Description

The GROUP function is equivalent to the FIELD function. It takes the general form:

GROUP(Expression1, Expression2, Expression3, Expression4)

Where:

  • 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.

Note: 

Expression2 may evaluate to more than a single character allowing fields to be delimited with complex expressions.

An example of use is as:

A = "123:-456:-789:-987:-"
CRT GROUP(A, ":-", 2, 2)

to display:

-456:-789

on the terminal being the second and third fields and their delimiter within variable A .


Go back to jBASE BASIC.

Was this article helpful?