VERIFIED SOLUTION i

Search and Replace: Invalid regular expression in Sagent

Product Feature: General transform use

 

Issue

For "Search and Replace transform", expression  "(?:.*?(,)){3} gives error "Invalid Expression".

 

Cause

Sagent has limited regular expression feature support, "()" parenthesis is not supported.
 

Resolution

UPDATED: April 3, 2017
Invalid regular expression error is returned for parenthesis "( )".

Workaround is to use VB script transform in dataflow.