Regex is an SSIS dataflow component that applies a configured regular expression against an incoming column, matching, extracting, or splitting, as configured by the user.
SQL Server SSIS Sample Component: Regex
SQL Server SSIS Sample Component: Regex