Difference between revisions of "STR REPLCE - Replace a sub-string of a string with another sub-string (Reports & Settings Report Generator function)"

From Catalyst
Jump to: navigation, search
(Updated from revision control)
 
(Updated from revision control)
Line 1: Line 1:
 
__NOTOC__
 
__NOTOC__
 
== Syntax ==
 
== Syntax ==
  '''$STR_REPLCE'''{String, Search sub-string, Replace sub-string, Count}
+
  '''$STR_REPLCE'''{string, search-sub-string, replace-sub-string, Count}
  
 
== Description ==
 
== Description ==
Line 8: Line 8:
  
 
== Parameters ==
 
== Parameters ==
;String
+
;string
 
: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 sub-string
+
;search-sub-string
 
: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 sub-string
+
;replace-sub-string
 
: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.

Revision as of 09:43, 21 April 2011

Syntax

$STR_REPLCE{string, search-sub-string, replace-sub-string, Count}

Description

Replace a sub-string of a string with another sub-string.


Parameters

string
A text parameter that can not be omitted.
The string that contains the sub-string.
search-sub-string
A text parameter that can not be omitted.
The sub-string, that will be searched for in the string.
replace-sub-string
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 text 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).