I need a script to extract data from website page automatically and store in to table .
I have a table which consists of url ‘s which points single website but each url points different page on the website . Table is given below . When ever you will open a url , you will landed on project page where project budget is mentioned . The work of the script will be :
(1) go to 1st url - search the webpage opened by url – extract the budget figures from that page and store the budget figures in that same table against that url or create a separate table and store data – which ever is faster and convenient
(2) Then go to 2nd url and and repeat same process till the end of urls’s
Note : some may not have budets figure available . in that acse null is stored
see the files for clarification