This function finds one text value within another and returns the text value’s position in the text you searched
- Library: PQL \ Spreadsheet \ Text
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
- Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions
Text you are trying to find; if empty (' '), the function matches the first character in the search string (that is, the character numbered start or 1); cannot contain wildcard characters
Text through which you are searching
Number representing character at which to start the search; the first character ofintextis 1; if omitted, the calculation starts at 1; if not an integer, the number is truncated
This function is the same as the Microsoft Excel 'FIND' function - using the same inputs, logic and outputs.