Regex String Stripper

Strips out all characters that match a Regex pattern and returns only the remaining characters

e.g
Strip out all numerics:
[0-9]

Strip out all alpha:
[A-Za-z]

Strip out all non-alphanumeric:
[^A-Za-z0-9]

Strip out specific characters that cannot be used in Windows file names:
[\\/:\*\?"<>\|]

Note that "\" must be used to escape special regex characters. The supplied regex pattern must be compatible with Java Regex

@takbb 29 June 2021 Brian Bates

Input ports

1. Type: Table
   Input Dataset
   The dataset containing a String column to which this transformation is to be applied

Output ports

1. Type: Table
   Output Dataset
   The output dataset containing the additional column with the transformation applied