Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)