The Replace String component transforms field values during a real-time single-table synchronization task in Data Integration. Add it between the Source and Destination nodes to find and replace strings in any text field before data reaches the destination. For more information about supported data sources, see Supported data sources and synchronization solutions.
Prerequisites
Before you begin, ensure that you have:
-
A configured data source. For more information, see Data source management.
-
A real-time single-table synchronization task. For more information, see Configure a single-table real-time synchronization task.
Add the Replace String component
-
Open your real-time single-table synchronization task, then turn on the Data Processing switch.
-
Click + Add Node and select String Replacement.
-
Click Add Rule. Add one rule per field transformation. Configure the following parameters:
Parameter Description Field name The text field from the previous node's output to transform. Content to be replaced The string to find. Replacement content The string to substitute. Regular matching When enabled, treats Content to be replaced as a Java regular expression (Pattern class). When disabled, performs a literal string search. Case sensitive When enabled, matching for Content to be replaced is case-sensitive. Literal mode (Regular matching off)
Content to be replaced and Replacement content support Java escape characters:
\t(tab),\n(line feed),\u0001(Unicode character).Regex mode (Regular matching on)
Content to be replaced accepts Java regular expressions. Use
$1,$2, and so on in Replacement content to reference captured groups.Examples
Mode Input Content to be replaced Replacement content Output Regex no.9526no.([0-9]+)$19526
-
Repeat step 3 to add more rules if needed.
Verify the output
After configuring the Data Source and the Replace String component, click Preview Data Output to preview the transformed field values and confirm the results meet your requirements.