DataWorks:Configure String Replace

Procedure

1. Go to the DataStudio page.

   Log on to the DataWorks console. In the top navigation bar, select the desired region. In the left-side navigation pane, choose Data Development and O&M > Data Development. On the page that appears, select the desired workspace from the drop-down list and click Go to Data Development.

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

   Alternatively, find the desired workflow in the Scheduled Workflow pane, right-click the workflow name, and then choose Create Node > Data Integration > Real-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.

4. Click Confirm.

5. On the configuration tab of the real-time synchronization node, drag String Replace in the Conversion section to the canvas on the right. Connect the String Replace node to the configured reader node.

6. Click the String Replace node. In the panel that appears, configure the parameters.

   

   Parameter	Description
   Rules	The rules that are used to replace the field values of the STRING type. Each rule is defined by the following parameters: Field: the field of the parent node that you want to use 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 that is used 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 Fields	The output fields after string replacement.

7. Click the icon in the top toolbar to save the node.