Welcome to the Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

Data Redaction

avatar
New Contributor

Hello My name is Adam.  I am new to string expressions.

Not sure if I am in the correct forum...

I have created a new redaction rule on the redaction policy screen

The rule will validate the date rule Search= ((19[789]\d|20[01]\d)(0[1-9]|1[012])(0[1-9]|[12][0-9]|3[01])) will redact valid dates 1970-2001 and month 01-12 and day 01-31.  What I need is redact what failes from the date validation rule above (in search).  What I need to do is any 8 digit number that is not a valid date should be redacted and any that is valid should not. 

for example 20185613 or 19990165 should be redacted but 20181231 or 19990101 should not...

Any suggestion on how to go about doing that?

Who agreed with this topic