EI Tables and Large Arrays

[voidblack]

I ran though the help files, hit up autoit 1, 2, 3, and have been trolling the forums for a few hours and I am still coming up short.

I have a table from a website which has several columns of information between 1000-2000 rows long. I only care about two columns, a date and a list of items. The items list has a variable amount of items in each cell which relate back to that date. I want to find a good way to allow AutoIt to take in the items and dates associated with them in such a way that they remain linked.

E.G.:

Table
Date    Items
2/2/10  99999, 324234, 24113123, 1232134123
1/2/10  56655625
3/2/10  454534534, 54453645

Array
2/2/10          1/2/10          3/2/10
99999           56655625        454534534
324234                          54453645
24113123
1232134123

The end goal will be to search a different website relating to each item for an event in another table around the date from the row the items came from.

http://www.funsite.wee/99999.html

Table2
Date       Event
9/9/10     No Fun
2/9/10     No Fun
2/2/10     No Fun
2/1/10     Fun!
2/2/09     No Fun
1/8/08     Fun!
1/3/08     No Fun
1/2/08     No Fun

I want to see that "Fun!" occurred on 2/1/10 on the website for item 99999 near the date from item 99999 (2/2/10), but ignore occurrences of fun more than a few day before 2/2/10 such as with 1/8/08

Any suggestions on how I can do this or learn how do get this done?

Edited December 5, 2010 by voidblack

[jchd]

As far as I can tell, the easiest way to acheive such storage/retrieval/query is (again) to use an SQLite database.

I woud build an ITEMS table with item, date (put it in ISO format for sorting, e.g. 2010/03/17) in each row.

Then a RATING table with date (ISO again) and rating.

After which you can query the DB very simply to fulfill your needs, and _much_ more.