FindColumnNumber (PQL)

Finds the index for the column containing a string.

  • Returned Output: Numeric
  • Library: PQL \ Dynamic \ Column
  • Version: 2018.00.000
  • Compatibility: Any content (regardless of data source) in the relevant parts of the application

Syntax

FindColumnNumber( <Text> , <Flag> )

* Click on the function's arguments above for more details on the input values.

Comments
  • The search text string is the exact text that will be searched across all provided column captions.
  • Set case sensitive flag to "true" to make the search case sensitive; set to "false" to make it insensitive.

Examples

The examples below use the following example grid.

This example returns the column index "0":

FindColumnNumber("bachelors","false")

This example returns the column index "-1", because there is no match:

FindColumnNumber("bachelors","true")