TEXTBEFORE (PQL - xl)

This function returns text that occurs before a given character or string

  • Library: PQL \ Spreadsheet \ Text
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

TEXTBEFORE(text, delimiter, OPTIONAL instance num, OPTIONAL match mode, OPTIONAL match end, OPTIONAL if not found)

Function Arguments

Name

Description

Type

Optional

text

Refers to the text you are searching within. Wildcard characters are not allowed. If the text is an empty string, it returns an empty text

String

delimiter

Refers to the text that marks the point before which you want to extract

String

instance num

Refers to the instance of the delimiter after which you want to extract the text. By default, instance_num = 1. A negative number starts searching text from the end

Number

Y

match mode

Determines whether the text search is case-sensitive. The default is case-sensitive. You can enter one of the following: 0 - case sensitive, 1 - case insensitive

Number

Y

match end

Treats the end of the text as a delimiter. By default, the text is an exact match. You can enter the following: 0 - Do not match the delimiter against the end of the text, 1 - Match the delimiter against the end of the text

Number

Y

if not found

Refers to the value returned if no match is found. By default, #N/A is returned

String

Y

Comments

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