PickBASIC / FlashBASIC

dcount() function

The dcount() function returns the number of occurrences of the delimiter specified in str.exp2 within str.exp1, plus one.

Syntax

dcount(str.exp1, str.exp2)

Parameter(s)


`str.exp1`	Specifies the string expression, plus one, in which to search for the delimiter specified in `str.exp2`.
`str.exp2`	Specifies the delimiter to locate within `str.exp1`.

Description

The difference between this function and the count() function is that 1 is added to the result unless the string referenced in str.exp1 is null.

Example(s)

how.many contains the number of attributes in string. In this example, there are 3 and each attribute displays on the terminal in a separate line.

string = "a" : char(254) : "b" : char(254) : "c"
how.many = dcount(string,char(254))
for amc = 1 to how.many
   crt string<amc>
next amc

In this example, sentence is entered from the keyboard. The string in sentence is trimmed of excess spaces, and the number of words delimited by spaces is counted using dcount(). The words are then printed on separate lines.

input sentence
sentence = trim(sentence)
maxwords = dcount(sentence,’ ’)
for wordcnt = 1 to maxwords
   print field(sentence,’ ’,wordcnt)
next wordcnt

Count the values in a multivalued field

fruits = "apple":@vm:"pear":@vm:"plum"
print "values: " : dcount(fruits, @vm)   ;* values: 3

Referenced by

1 topic mentions dcount() function in its description.

Performance