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 that will be used to count the fields.

NOTES

The delimiter string may consist of more than 1 character.

If expression1 is a NULL string, then the function will return a value of 0.

The delimiter string may consist of any character, including system delimiters such as field marks or value marks.

Also see COUNT.

EXAMPLES

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

will display the value 4.

jBC