TEXTSPLIT (PQL - xl)

This function splits text strings by using column and row delimiters

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

Syntax

TEXTSPLIT(text, delimiter, OPTIONAL text delimiter, OPTIONAL ignore empty, OPTIONAL match mode, OPTIONAL pad with)

Function Arguments

Name

Description

Type

Optional

text

Refers to the text you want to split

String

delimiter

Refers to the text that marks the point where to spill the text across columns

String

text delimiter

Refers to the text that marks the point where to spill the text down rows

String

Y

ignore empty

Specify FALSE to create an empty cell when two delimiters are consecutive. Defaults to TRUE, which creates an empty cell

StringOrNumber

Y

match mode

Searches the text for a delimiter match. By default, a case-sensitive match is done

Number

Y

pad with

Refers to the value with which to pad the result. The default is #N/A

StringOrNumber

Y

Comments

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