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
IA Data Rules with regexp
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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 ?
Can you compare both results with a third utility, maybe grep ?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Make sure you test your regex with a Java-based regex tester. I have http://java-regex-tester.appspot.com bookmarked...
Regards,
Robert
Robert