New answers tagged select-by-attribute
I assume that your files are in the same directory. I don't know why you Have to use a for loop, as it adds unnecessary complexity, but here is an example where you can create two lists (one with the lower ranges and the second with the upper ranges), that you insert into the where clause when creating the layer (you can also create a single layer without ...
Yes, it'll select all rows where the COMMENTS field is empty. I just tested and it also selected rows with a single space: ' ' (tested with an .mdb feature class). However, it will not select Null values (use IS NULL for that).
You can use greater-than and less-than operators on dates, so something like this: "CHANGE_DATE" > date '2012-12-31 00:00:00' AND "CHANGE_DATE" < date '2014-01-01 00:00:00' Would work to grab all the dates for the year 2013. Note that the specific syntax of the query can change slightly depending on the data source. The above is for a file ...
Top 50 recent answers are included