Selecting certain records from an Array

[texan]

Let's say I have a 2 dimensional array that contains 3 columns and thousands of rows. The three columns contain data for STATE, COUNTY and CITY and all the rows are every combination of this data in the US.

I am looking for some method of returning a new array that contains all the data that matches some subset of the main array. For instance, I want all the cities in NY so I would want the new array to countain all the rows where the STATE is equal to "NY".

I could easily right SQL to do this on a table but I am not seeing any easy method in Autoit. Any suggestions?

I have been looking at various _Array* functions but none seem to do this. _ArrayUnique is close.

[water]

_ArraySearch + some code to fill the new array?

[UEZ]

You can use also SQL with AutoIt. Search the forum for plenty of examples.

Br,

UEZ

[Mechaflash]

The SQL UDF allows you to use SQL syntax to query information from the database. If the data resides a database, might as well just use the UDF.