Replacing a mark in a column - ColumnsReplace

Within the input data, we can replace single characters or strings.

Example:

In the dynamic column "mobile" we get a value with an extra # character from the input data. So we want to remove this character (replace it with nothing).

Input data	Modified data
4206#03969082	420603969082
4207#73647862	420773647862
4206#03324573	420603324573
4206#06673932	420606673932
4206#06167157	420606167157
4207#77077615	420777077615
4206#08866274	420608866274

Syntax:

<ColumnsReplace>
<string>dynamic;mobile;#;</string>
</ColumnsReplace>

In general:

<ColumnsReplace>
<string>1;2;3;4</string>
</ColumnsReplace>

1. column category (dynamic column)
2. column name (mobile, email...)
3. replaced character (#, ?...)
4. character replacing ()