FINDCHARS

The FINDCHARS function returns the character position of the beginning of a specified group of characters within a text expression.

Return Value

INTEGER

Syntax

FINDCHARS(text-expression, characters [starting-pos [LINENUM]])

Arguments

text-expression

The text expression in which you are searching for the specified characters. Text-expression can be a multiline value. In this case, FINDCHARS searches all lines for the specified characters. The match must be exact, including a match of upper- and lowercase characters. See "TEXT and NTEXT".

characters

The group of characters for which you are searching. When characters is a multiline value, FINDCHARS ignores all lines except the first one.

When characters is not found in text-expression, FINDCHARS returns zero. When the group of characters occurs more than once, FINDCHARS returns the position of its first occurrence.

starting-pos

An INTEGER expression that specifies the character position where the search in text-exp should start. The default is at position 1 (the first character) in text-exp.

LINENUM

Specifies that FINDCHARS should return the line number instead of the character position of the beginning of the specified text.

Notes

When you are using a multibyte character set, you can use the FINDBYTES function instead of the FINDCHARS function.

FINDCHARS accepts TEXT values and NTEXT values as arguments. When only one argument is NTEXT, then FINDCHARS automatically converts the other argument to NTEXT before performing the function operation.

Examples

SHOW FINDCHARS('hellotherejoe', 'joe')

11

SHOW FINDCHARS('hellotherejoe', 'al')

0