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 plug-in: 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.