Extracting Data Using Regular Expressions

Use regular expressions to match a specific text pattern in your column data and extract it to a new column.

To extract data using regular expressions:

1. On the main authoring page, identify the transform column that contains the data you want to extract to a new column.
2. In the Column cell, click the More Actions icon.
   A drop-down list appears.
3. Select Extract with Expression.
   The Extract with Expression dialog box appears. The Sample Value field is auto-populated with a value from the selected column.
4. In the Column Name field, enter a name for the new column that will contain the extracted data.
5. In the Regex Field, enter the regular expression to identify the text you want to extract.
   The example in the following screenshot searches for the string that starts with the @ symbol in the data and matches any number of characters after that.
   
   Description of the illustration regex_extract_data_1.png
   
6. Confirm that the Regex Result field displays the expected output and click Apply.
   The following screenshot shows the extracted text for the regex example used in the previous step.
   
   Description of the illustration regex_extract_data_2.png
   

The sample data is updated and the text identified by the regular expression is extracted into a new column.