Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hello,
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.
Please have a look at this online documentation about: TalendHelpCenter: creating-regular-expression-function-on-sql-server
Best regards
Sabrina