Request regarding extracting data from a website

itsme220

Senior Member
Joined
Sep 1, 2006
Messages
620
Reaction score
0

davidktw

Arch-Supremacy Member
Joined
Apr 15, 2010
Messages
13,550
Reaction score
1,302
I need to extract data from a website and formulate in excel file

example

http://dev.mydomain.com/Master/dbcheck.aspx?infoID=237
http://dev.mydomain.com/Master/dbcheck.aspx?infoID=100
http://dev.mydomain.com/Master/dbcheck.aspx?infoID=650
http://dev.mydomain.com/Master/dbcheck.aspx?infoID=980

The InfoID will change from 1 to 999
so I need to extract data from nearly 1000 pages.

Is there any tools or simple coding I can do to extract?

Thanks

Assuming no post processing
Code:
# for i in `seq 1 999`; do curl "http://dev.mydomain.com/Master/dbcheck.aspx?infoID=$i"; done

If you have a script to do whatever you need
Code:
# for i in `seq 1 999`; do ./yourscript.sh "http://dev.mydomain.com/Master/dbcheck.aspx?infoID=$i"; done
 
Last edited:
Important Forum Advisory Note
This forum is moderated by volunteer moderators who will react only to members' feedback on posts. Moderators are not employees or representatives of HWZ Forums. Forum members and moderators are responsible for their own posts. Please refer to our Community Guidelines and Standards and Terms and Conditions for more information.
Top