IA Data Rules with regexp

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
ktrogers
Participant
Posts: 8
Joined: Tue Sep 27, 2016 9:17 am
Location: Albuquerque, NM

IA Data Rules with regexp

Post 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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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 ?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

Make sure you test your regex with a Java-based regex tester. I have http://java-regex-tester.appspot.com bookmarked...
Regards,
Robert
Post Reply