Automated data collection from the net database

[vincent81]

hi ..i have a little problem here...if u go to this site,
http://www.singaporepools.com.sg/fd_results3yrs/
u see the scroll down button...there are a lot of dates...each date links to a page in which i want to copy some data into a text file.
and this apples to all other dates...

anyone know any program which can do this job?

 

[Nice coder]

load into array(single dimentional, one cell per character)
open "C:\Textfile.txt" for output as #1
for x = 2 to ubound(array()) - 2
if isnumerical(array(x)) then
if isnumerical(array(x + 1)) then
if isnumerical(array(x + 2)) then
if isnumerical(array(x - 1)) then
if isnumerical(array(x - 2)) then
print #1, array(x)
end if
end if
end if
end if
end if
next x
close #1

Hopefully this code will help you

 

[ravenprp]

There are several programs that can help with automated data collection from a website's database. One option is to use a web scraping tool, which can extract data from a website and save it in a structured format such as a text file. Another option is to use a programming language like Python or JavaScript to write a script that automates the process of navigating through the pages and extracting the desired data. It may also be helpful to consult with a web developer or data analyst for assistance with this task.