I'm wondering what definition query to use to not display features in a field. For example, field is "Name", data is PETROLEUM WELL NO 1 TH and I do not want features with TH in them displayed.
Ignores 'TH' anywhere': "Name" Not Like '%TH%'
Ignores 'TH' only at the end: "Name" Not Like '%TH'
Ignores 'TH' preceded by a space: "Name" Not Like '% TH%'
etc.
Building a query expression—Help | ArcGIS for Desktop
Of course, that definition query ('% TH %') will not match your original example ('PETROLEUM WELL NO 1 TH'), which does not end in a space.
in my case the TH can appear anywhere, and the data is different lengths...looks like I have success with "Name" NOT LIKE '% TH %'
NOT YourField LIKE '%TH'
with the appropriate field designators depending on the source table (and I am not sure if NOT has to be outside the field or you can use NOT LIKE... not near Arc* now) But the key is to use a wildcard and TH the example shown is if the field always ends in TH use %TH otherwise %TH% but that will find a whole bunch of others I suspect. So once you have selected those, then NOT switches the selection leaving those behind
EDIT Too slow... never get a coffee mid answer
excellent, thank you very much...have a great day!
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
