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?

DCOUNT

Description

This function counts the number of field elements in a string that are separated by a specified delimiter. It takes the general form:

DCOUNT(expression1, expression2)

Where:

  • expression1 evaluates to a string in which fields are to be counted.
  • expression2 evaluates to the delimiter string used to count the fields.

Note:

  • The delimiter string may consist of more than one character.
  • If expression1 is a NULL string, the function returns a value of zero.
  • The delimiter string may consist of any character, including system delimiters such as field marks or value marks.

An example of use is as follows:

A = "A:B:C:D"
CRT DCOUNT(A, ":")

The above code will display the value 4


See also: COUNT.

Go back to JBASE BASIC.

Was this article helpful?