FIND (PQL  xl)
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 plugin: both as part of the objective function and constraint functions
Syntax
FIND(find text, within text, OPTIONAL start num)
Function Arguments
Name  Description  Type  Optional 
find text  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  String 

within text  Text through which you are searching  String 

start num  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  Number  Y 
Comments
This function is the same as the Microsoft Excel 'FIND' function  using the same inputs, logic and outputs.