Purpose

DCOUNT counts the occurrences of delimiters in a string.
 

Syntax

variable = DCOUNT (operand1,operand2)
 

Operation

operand1 is any valid alphanumeric string
operand2 is any valid alphanumeric literal or variable specifying the delimiter characters to be counted in the string
variable is any numeric variable
 

Remarks

DCOUNT counts the number of occurrences of any of the characters within operand2 that occur in operand1.
 

Example
 

#A = DCOUNT (“HELLO,WORLD",“,")......................gives #A = 1

#A = DCOUNT (“HELLO,WORLD",“Z").....................gives #A = 0

#A = DCOUNT (“,",“,")..........................................gives #A = 1

#A = DCOUNT (“ROGER, ANDY AND FRANK",“ ,")....gives #A = 4

#A = DCOUNT(“ROGER, ANDY AND FRANK",“,")......gives #A = 1