topic Re: Issues using metacharacters in Regular Expression check in ArcGIS Data Reviewer Questions

Issues using metacharacters in Regular Expression check

KatieMcHugh1 — Mon, 28 Jan 2013 15:54:52 GMT

Hi,

I am trying to create regular expressions using metacharacters, but either I am doing something wrong or something isn't working.
My understanding is that the results of a regular expression check will produce the records where the regular expression is not
matched.

As an example of what I am doing: I have a test feature class with a field that has 16 of the same value (ACEC), 2 of another
(Inholding) and 2 nulls. I think that using the expression ^[AC] should produce the records that do not begin with "AC". Thus,
there should be 4 records in the results (the 2 "Inholding" and 2 nulls). Instead the check results show all 20 records.

I have tried this with a variety of metacharacters, and have had no luck with any. Is there something that I am not doing
correctly, or am I misunderstanding how to use these characters in a regular expression query?

Thank you,
katie

Re: Issues using metacharacters in Regular Expression check

DanHopkins — Wed, 30 Jan 2013 18:31:46 GMT

Hi Katie,

Please construct the following regular expression:

AC[A-Za-z]*

What happens?

Regards,
Dan

Re: Issues using metacharacters in Regular Expression check

KatieMcHugh1 — Fri, 08 Feb 2013 15:25:13 GMT

Hi Dan,

Sorry for my delayed response, I've been out for a few days. That did what I wanted. Is there any chance you could deconstruct
that for me so I understand how each of the characters are functioning?

Cheers,
katie

Re: Issues using metacharacters in Regular Expression check

TuanVu_Huu — Sun, 16 Aug 2020 20:09:15 GMT

Dear Dan,

I am Tuan from Esri Vietnam.

I am help customer in vietnam to build table check and I using Regular Expression check. I have try to check value field name of map sheet as like this : 6636-V-DN

And I have try expression as :

([0-9][0-9][0-9][0-9]-\[A-Z]-\[A-Z][A-Z])

But it is not return the error.

Moreover, when I have set some expression for other field it is work but it not check for NULL or Space value?

Please help!

Many thank in advance!

Vu Tuan