====== Replace ======

The Replace () function gets a string, the string to be replaced and optionally the new string as a parameter. 
As a result, this function returns the string with the replaced string. If the third parameter is not specified, the character to be replaced is replaced by an empty string.\\  

==== Syntax: ====

<code>Replace('String', 'String to replace', 'String to be used')</code>

==== Sample: ====

<code>Replace('Name1', '1')</code>
returns Name
<code>Replace('Name1', '1', '2')</code>
returns Name2
<code>Replace('Name123123', '1', '5')</code>
returns Name523523
<code>Replace('Na'me'," ' ")</code>
returns Name
<code>Replace($DocNumber, '%', '1')</code>
replaces all % of the string in the variable //$DocNumber// with 1.
<code>Replace(@DocumentNumber, '%', '1')</code>
replaces all % of the string in the field //@DocumentNumber// with 1.
<code>Replace(@DocumentNumber, " ", "")</code>
removes all spaces from the string in the field @DocumentNumber. \\\ 
**caution:** in this case, use double quotation marks.

{{:images:sign_warning.png?nolink|}}**Note:** To replace special characters, e. g. of Carriagereturn/Linefeed, use the function Replace() together with the function [[en:transformation:mappings:funktionen:string:char|Char()]].
<code>Replace(@Text, Char(13,10), '<p/>')</code>
replaces Carriagereturn - Linefeed with <p/>