Unsupported use of regular expressions on this database _TOS for Data Quality
I’m new to talend and trying to use the profiler tool to analyse data in Database using MS SQL Server. I'm using regex patterns to check if datatype in a field is datetime. When I choose Regex_Date, i encounter an error. How should I fix this?
Microsoft SQL server does not natively support regular expressions. After you create the regular expression function, you should use the studio to declare that function in a specific database before being able to use regular expressions on analyzed columns.
