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
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.