PDA

View Full Version : automated data collection from the net database


vincent81
Jan5-04, 10:43 AM
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
Feb20-04, 05:03 AM
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