Difference between revisions of "STR REPLCE - Replace a sub-string of a string with another sub-string (Reports & Settings Report Generator function)"
From Catalyst
(Updated from revision control) |
(Updated from revision control) |
||
| Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ | ||
== Syntax == | == Syntax == | ||
| − | '''$STR_REPLCE'''{string, search | + | '''$STR_REPLCE'''{string, search, replace, count} |
== Description == | == Description == | ||
| Line 13: | Line 13: | ||
:A text parameter that can not be omitted. | :A text parameter that can not be omitted. | ||
:The string that contains the sub-string. | :The string that contains the sub-string. | ||
| − | ;search | + | ;search |
:A text parameter that can not be omitted. | :A text parameter that can not be omitted. | ||
:The sub-string, that will be searched for in the string. | :The sub-string, that will be searched for in the string. | ||
| − | ;replace | + | ;replace |
:A text parameter that can be omitted. | :A text parameter that can be omitted. | ||
:The substring, that will replace the Search sub-string in the main string. This defaults to nothing, the effect being that the Search sub-string will simply be removed. | :The substring, that will replace the Search sub-string in the main string. This defaults to nothing, the effect being that the Search sub-string will simply be removed. | ||
| − | ; | + | ;count |
| − | :A | + | :A numeric parameter that can be omitted (it defaults to "0"). |
:The occurence of the Search sub-string to replace | :The occurence of the Search sub-string to replace | ||
:;0 | :;0 | ||
Revision as of 06:58, 5 March 2016
Syntax
$STR_REPLCE{string, search, replace, count}
Description
Replace a sub-string of a string with another sub-string.
You may enclose any of the string or substring parameters between "[" and "]" to include leading or trailing spaces.
Parameters
- string
- A text parameter that can not be omitted.
- The string that contains the sub-string.
- search
- A text parameter that can not be omitted.
- The sub-string, that will be searched for in the string.
- replace
- A text parameter that can be omitted.
- The substring, that will replace the Search sub-string in the main string. This defaults to nothing, the effect being that the Search sub-string will simply be removed.
- count
- A numeric parameter that can be omitted (it defaults to "0").
- The occurence of the Search sub-string to replace
- 0
- Will replace all occurences of the Search sub-string.
- 1
- Will replace the first occurence of the Search sub-string.
- 2
- Will replace the second occurence of the Search sub-string.
- -1
- Will replace the last occurence of the Search sub-string.
- -2
- Will replace the penultimate occurence of the Search sub-string.
Returns
A text value. The string with the replacement(s).
