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

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