SUBSTITUTE (PQL - xl)
This function substitutes a new string for specified characters in an existing string
- Library: PQL \ Spreadsheet \ Text
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
SUBSTITUTE(text, old text, new text, OPTIONAL instance num)
Function Arguments
Name | Description | Type | Optional |
text | String or reference to a cell containing the string in which you want to replace characters | String |
|
old text | String to be replaced | String |
|
new text | New string to use instead of existing string | String |
|
instance num | Which occurrence of the existing string to replace; otherwise every occurrence is replaced | Number | Y |
Comments
This function is the same as the Microsoft Excel 'SUBSTITUTE' function - using the same inputs, logic and outputs.