AnsweredAssumed Answered

use of Regular Expressions in Data reviewer checks?

Question asked by MartinHvidberg on May 22, 2012
Latest reply on Aug 18, 2020 by michelle_johnson-esristaff
Dear Forum

I???m trying to use Data Reviewer to catch invalid dates in a string (TEXT) field.

I use the "Regular Expression Check Properties" in "Table Checks".

My field holds date values of form YYYYMMDD, e.g. 19660313

I tried to write a Regular Expression to fit this, some thing like:
([0-9][0-9][0-9][0-9])(0[1-9]|1[0-2])(0[1-9]|[12][0-9]|3[01])

But Data Reviewer keeps returning all records as errors, so obviously I???m doing something wrong.

Can anyone help me to a good R.E. expression, which would identify only the dates that do not match the YYYYMMDD format?

Best regards
Martin

Outcomes