SEARCHB (PQL - xl)

This function searches 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

Syntax

SEARCHB(find text, within text, start)

Function Arguments

Name

Description

Type

Optional

find text

Refers to the 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

Refers to the text through which you are searching

String

start

Refers to the number representing character at which to start the search. The first character of within text argument is 1. If this value is omitted, the calculation starts at 1. If this value is not an integer, the number is truncated

Number

Comments

This function is the same as the Microsoft Excel 'SEARCHB' function - using the same inputs, logic and outputs.