RegEx Replace

Parent Previous Next


RegEx Replace Transform


The "RegEx Replace Transform" allows the user to replace or extract data from a source column using regular expressions.



Input Columns

o   Input Columns

o   Choose Action - The RegEx Replace Transform has 2 actions that can be used to either replace or extract data from a source column.

 Replace matching regular expression pattern with a user defined value  - This action will allow the user to define a regular  expressions to search column data and replace the data if the regular expression matches.

 Extract Data from input string using regular expression - This action will extract data from a source column using  regular expression


Please see the Error Row Handling page for more information about this functionality.