String Replace is a transformation plug-in used to replace field values of the STRING type.

Prerequisites

A reader node is configured. For more information, see Supported data stores for real-time synchronization.

Procedure

  1. Go to the DataStudio page.
    1. Log on to the DataWorks console.
    2. In the left-side navigation pane, click Workspaces.
    3. Select the region where the required workspace resides, find the workspace, and then click Data Analytics.
  2. Move the pointer over the Create icon and choose Data Integration > Real-time synchronization.
    Alternatively, you can click the required workflow, right-click Data Integration, and then choose Create > Real-time synchronization.
  3. In the Create Node dialog box, set the Node Name and Location parameters.
    Notice The node name must be 1 to 128 characters in length. It can contain letters, digits, underscores (_), and periods (.).
  4. Click Commit.
  5. On the configuration tab of the real-time sync node, drag String Replace under Conversion to the canvas on the right. Connect the new node to a reader node.
  6. Click the new String Replace node. In the configuration pane that appears, set the required parameters in the Node configuration section.
    String Replace
    GUI element Description
    Rules The rules for replacing field values of the STRING type. A rule is defined by the following parameters:
    • Field: the field of the parent node to be used as the input field.
    • Regular matching: specifies whether a regular expression is used to search for the original string.
    • Original string: the original string to search.
    • New string: the new string to replace the original string.
    • Case Sensitive: specifies whether the value is case-sensitive during the search.
    Add condition Click this button to add more string replacement rules.
    Output field The output fields after string replacement.
  7. Click the Save icon in the toolbar.