FIND (Report Builder 1.0)

Position of the first instance of a substring.

Syntax

FIND(string, substring)

string

Specifies the string that contains the substring for which to search.

substring

Specifies the substring to locate.

Remarks

  • If the string is not found, a zero is returned.

Example

Formula

Result

FIND("A light yet stiff aluminum bar for long distance riding.", "aluminum bar")

Returns the number of character spaces within the string that the substring begins. In this example, 19.

FIND(Description, "aluminum")

Returns a list of values that indicates the number of character spaces within the string that the substring begins, similar to the following:

10

19

0