Replacing Data Using Regular Expressions

Use regular expressions to match a specific text pattern in your column data and remove or replace it with a different text string.

To replace data using regular expressions:

1. On the main authoring page, identify the transform column that contains the data you want to replace.
2. In the Column cell, click the More Actions icon.
   A drop-down list appears.
3. Select Expression Search and Replace.
   The Expression Search and Replace dialog box appears. The Sample Value field is auto-populated with a value from the selected column.
4. In the Regex Search field, enter the regular expression you want to use to identify the text to be replaced.
   The following screenshot shows an example of a regular expression string \d* that is used to search for any number of digits.
   
   Description of the illustration regex_replace_0.png
   
5. In the Regex Search field, enter the regex expression you want to use to replace the text you identified.
    In the example used for the following screenshot, the Regex Replace field is left empty in order to replace the identified text with null. In order words, the identified text will be removed from the column.
   
   Description of the illustration regex_replace_1.png
   
6. Confirm that the Regex Result field displays the expected output and click Apply.

The sample data is updated and the text identified by the regular expression is replaced.