We seek to extract data from a website.
This data can be seen here http://www.1stchoice.co.uk/LatestRequests2.aspx
The data ENTRY by the customer is here :
http://www.1stchoice.co.uk/UOrder2.aspx?CT=2
The data is enquiries for car parts. From the data we can see WHAT car parts are requested most.
We are sellers of car parts, so we will use the information to buy the most useful old cars.
We seek to have the data extracted and split so we can analyse it by manufacturer, model, year etc.
We can do this in Excel but manually it is slow. Also, the fields are combined and need to be separated (to manufacturer, model, year , engine size etc).
We seek the best separation and sorting of data. But if it is too hard or too difficult, then something simpler can be done. We only want to see what cars and what parts are asked for ...in a more detailed way than we can do in Excel by copying and pastiing one page at a time.
Even just to copy and paste and remove hyperlinks in Excel would be very good. If the data can be sorted / separated further, even better.
From the links above, you can see how customers ENTER their data. And then you can see how it is presented.
Re the Price to pay ? We dont know what this should cost nor what software expert to seek ( PERL ?). Please make us your offer.