Page 1 of 1

IA Data Rules with regexp

Posted: Fri Sep 30, 2016 1:28 pm
by ktrogers
Trying to use regular expressions in Data Quality rules and not getting the expect results. When we run the regexp in Oracle SQL, we get different results.


New to IA and don't know how to troubleshot the issue.


Thanks in advanced

Posted: Fri Sep 30, 2016 4:03 pm
by ray.wurlod
Can you provide examples? The matches_regexp check should work with any well-formed regular expressions. I've never had a problem with it.

Can you compare both results with a third utility, maybe grep ?

Posted: Wed Oct 12, 2016 6:16 am
by rjdickson
Make sure you test your regex with a Java-based regex tester. I have http://java-regex-tester.appspot.com bookmarked...