topic Re: How to do Multiple Regular Expression Checks in a Single Field in ArcGIS Data Reviewer Questions

How to do Multiple Regular Expression Checks in a Single Field

TedCronin — Wed, 28 Aug 2013 00:28:58 GMT

Is it possible to use an Or inside of a Regular Expression Check somehow, for example as TR 12345 or TR 1234, something to the effect of [A-Z][A-Z] [0-9][0-9][0-9][0-9][0-9] OR [A-Z][A-Z] [0-9][0-9][0-9][0-9].

I know the above does not work, but what is the recommended approach for doing Multiple Regular Expression Checks in a Single Field.

Another Occurrence would be TR 12345 OR TR 12345-1, because conceptually I can solve this (TR 12345 or TR 1234) as

[A-Z][A-Z] [0-9]+

Re: How to do Multiple Regular Expression Checks in a Single Field

GISDev1 — Wed, 28 Aug 2013 01:55:57 GMT

In you use-case examples, multiple expressions don't seem to be necessary.
What's wrong with the "+" solution you posted?

Re: How to do Multiple Regular Expression Checks in a Single Field

TedCronin — Wed, 28 Aug 2013 12:50:50 GMT

Absolutely, that does work, but what I really need is where I have a Tract with a number and a Tract with a -1 at the end. Really bad example on my part I suppose, since I already use the [A-Z][A-Z] [0-9]+ where I can do exactly what I asked such as grabbing a 4 + digits.

Other examples where I need an OR MB 000/000 OR MB 000/000 SD...

Re: How to do Multiple Regular Expression Checks in a Single Field

TedCronin — Wed, 28 Aug 2013 13:46:10 GMT

It would be nice to add to the Composite Check the ability to add a SQL Check and then combine the SQL Check with a Regular Expression Check, or even a couple of Regular Expressions Checks where, I can Extract out what I am referring here in an OR via SQL, then be able to stack multiple Reg Expressions, essentially.

Re: How to do Multiple Regular Expression Checks in a Single Field

MichelleJohnson — Wed, 28 Aug 2013 16:40:49 GMT

Use | as the OR. For example,

TR 12345-1 OR TR 12345 OR TR 1234
([A-Z][A-Z] [0-9][0-9][0-9][0-9][0-9]\-[0-9])|([A-Z][A-Z] [0-9][0-9][0-9][0-9][0-9])|([A-Z][A-Z] [0-9][0-9][0-9][0-9])

MB 000/000 SD OR MB 000/000
([A-Z][A-Z] [0-9][0-9][0-9]\/[0-9][0-9][0-9] [A-Z][A-Z])|([A-Z][A-Z] [0-9][0-9][0-9]\/[0-9][0-9][0-9])

Cheers,
michellej.

Re: How to do Multiple Regular Expression Checks in a Single Field

TedCronin — Wed, 28 Aug 2013 17:14:35 GMT

Sweeet.

Cheers Indeed.

I was not seeing the expected results with just using Spaces, but explicitly insert white Space seems to do the trick.

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

Seems like the | can get inserted into the Help for OR, what is the symbol for AND. Currently | is Matches an alternative phrase or spelling, in the help.

I also like how you use () and use \ for even /...