DataWorks:Configure String Replace

Procedure

1. Go to the DataStudio page.

   1. Log on to the DataWorks console.

   2. In the left-side navigation pane, click Workspaces.

   3. In the top navigation bar, select the region in which the workspace that you want to manage resides. On the Workspaces page, find the workspace and click Shortcuts > Data Development in the Actions column.

2. In the Scheduled Workflow pane, move the pointer over the icon and choose Create Node > Data Integration > Real-time synchronization.

   Alternatively, right-click the required workflow, and then choose Create Node > Data Integration > Real-time synchronizationReal-time synchronization.

3. In the Create Node dialog box, set the Sync Method parameter to End-to-end ETL and configure the Name and Path parameters.

   Important

   The node name cannot exceed 128 characters in length and can contain letters, digits, underscores (_), and periods (.).

4. Click Confirm.

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.
   

   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 icon in the toolbar.