Previous Topic: COMMONDN Function--Find a Common Root

Next Topic: DATE Function--Set to Midnight (form 1)

COUNT Function--Count the Elements in a Set

The COUNT function counts the number of elements in a set.

Syntax

The COUNT function has the following format:

COUNT(set[, case_sensitive])

Parameters

The COUNT function accepts the following parameters:

set (string)

Specifies a string of elements that are separated by the caret character: 'element1^element2'. Each element is a string.

case_sensitive (Boolean)

(Optional) Specifies case sensitivity.

Return Value

The COUNT function returns a number.

Example

Return_value=COUNT('phoebe^PHOEBE^robin^robin')
Return_value=4

Return_value=COUNT('phoebe^PHOEBE^robin^robin', FALSE)
Return_value=2

Return_value=COUNT('phoebe^PHOEBE^robin^robin', TRUE)
Return_value=3

More information:

ENUMERATE Function--Test Set Elements

FILTER Function--Test Set Elements

SORT Function--Sort a Set


Copyright © 2010 CA. All rights reserved. Email CA about this topic