I have ArcGIS Pro 3.2 Advanced with no additional licenses. I want to create a definition query to query my address2 field for any upper and lower cases letters or numbers. I am trying to isolate where blank cells and spaces are improperly imported from excel. I am currently messing around with a definition query to get my table view to show the selection I want. I have 4,460 records and 3,857 are blank.
When I construct my definition query:
where address2 NOT LIKE '%([A-Za-z0-9])%'
This should query out value in address2 that has an upper or lower case letter A through Z and any number 0 through 9.
but it only excludes 2 records, is ArcGIS Pro unable to support ranges and regular expressions?
I have tried several variations of my range to include word boundary \b, and + signs.
I currently have it written the most difficult way of each individual letter and number........
Edit: This is in a file geodatabase, and I tried to construct the definition query by adding a standalone table to the map and building it in the sql expression builder window. Specifically using the radio button to write out my own sql expression.
