Solved! Go to Solution.
Dear Michelle,
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
Dear Michelle,
sorry I mean I have typed expression as: 6636-V-DN
([0-9][0-9][0-9][0-9]-\[A-Z]-\[A-Z][A-Z]) too
But still not get error.
many thanks,
Vu Tuan
Vu Tuan,
There is an option to check for NULLs. It will not flag fields with blanks. But I think that the expression should flag those. If it does not, then you can create an Execute SQL Check to look for NULL and blanks.
Regards,
michellej.
Dear Michelle,
I have added some option, But still fail.
([0-9][0-9][0-9][0-9]\-\[A-Z]\-\[A-Z][A-Z])
([0-9][0-9][0-9][0-9])\-([A-Z])\-([A-Z][A-Z])
([0-9][0-9][0-9][0-9]-[A-Z]-[A-Z][A-Z])
Please advice
Vũ Tuấn
Hello Vu Tuan,
I used the last option you provided, ([0-9][0-9][0-9][0-9]-[A-Z]-[A-Z][A-Z]), and I was getting expected results. I'm assuming that your format must be like 6636-V-DN.
I created sample data with good and bad formatting. The highlighted records were returned. They do not follow format of 4 digits, dash, 1 capital letter, dash, 2 capital letters.
Regards,
michellej.