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

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 occurrence of the Search sub-string to replace

0

Will replace all occurrences of the Search sub-string.

1

Will replace the first occurrence of the Search sub-string.

2

Will replace the second occurrence of the Search sub-string.

-1

Will replace the last occurrence of the Search sub-string.

-2

Will replace the penultimate occurrence of the Search sub-string.

Returns

A text value. The string with the replacement(s).