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

  1. Log on to the DataWorks console. In the left-side navigation pane, click Workspaces. On the Workspaces page, find the target workspace and click Data Analytics in the Actions column.
  2. On the Data Analytics tab, move the pointer over the Create a sync node icon and choose Data Integration > Real-Time Sync.

    You can also find the target workflow, right-click Data Integration, and choose Create > Real-Time Sync.

  3. In the Create Node dialog box that appears, set Node Name and Location, and then click Commit.
  4. On the configuration tab of the created real-time sync node, drag String Replace under Transform to the editing panel. Connect it to the desired reader in the panel.
  5. Click the string replacement node and set parameters in the Node Settings section.
    • Node Settings
      Rule:
      • Field: the field of the parent node to be used as the input field.
      • Regular Expression Match: 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 the button to add more string replacement rules.

    • Output Fields

      The output fields after string replacement.

  6. Click Save the settings in the toolbar.