FIND (Report Builder)
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 |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Text Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Data, Text, and Images (Report Builder)