jBase Infobasic Command DCOUNT

The DCOUNT( ) function counts the number of field elements in a string that are separated by a specified delimiter.

Command Syntax

DCOUNT(expression1, expression2)

Syntax Elements

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

Notes

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.

See also COUNT

Example

A = "A:B:C:D"

CRT DCOUNT(A, ":")

Output will be: 4