"Select by Attributes" query script

ArielCarballo

Hi,

 

I need to write a script that would extract the contents of a text file (see below)

 

123456

234567

890123

567890

 

and would write a script that later could be loaded when using "Select by Attributes" tool (see below).

 

 

P.S. I have a list of hundreds of numbers that I do not want to enter them one by one.

Your help would be greatly appreciated.

Thanks

AntGiles

Ariel,

if you have your list in a text document you could load it in to excel so each value is in separate rows down one column.

then create a formula to create your expression, e.g:

= "FID = '" & A1 & "'"

where A1 is the first cell that contains a value. Copy the formula down so that each row gets populated. If you the copy the values into notepad then copy and paste them into word ( this stops the column being added as a table in word). You can then do a find and replace to add the 'or' segments into your expression. ^p in word is hard return replace this with space OR space. This should give you your full expression that you can then paste into arcmap.

hope this helps

anthony