Checks how often a value occurs.

Example: if column A contains "An A 1x2x3x4x5", the result will be 5.

Syntax

XIH.Count(colcaption, value)

Parameters

Parameter

Data type

Description

Sample

colcaption

string

String specifies the columns caption.

"col1"

value

int

The character that will be counted

"A"

Remarks

Also supports "TAB” and “CR“ as input values (Tab = tabulator, CR = carriage return).

Returns an integer.

Examples

XIH.Count("NumberOfA", "A")

Checks how often A is in one row of the Column.

Related