You have to login in order to post a reply to this topic.

4 replies [Last post]
notjes
notjes's picture
User offline. Last seen 1 year 33 weeks ago. Offline
Joined: 06/17/2010
Posts: 2

hi ther

 

xls file that read 22636 lines search line by line in google to find what program is?

 

is it possible to do

D.M.Altizer
User offline. Last seen 1 year 11 weeks ago. Offline
Joined: 01/12/2010
Posts: 204
Re: mission imposible

 Your description is not very clear. Can you please try to describe in more detail what you are trying to do? We will also need a sample Excel file...

__________________

==Dedicated Automation Solutions==

__________________

==Dedicated Automation Solutions==

notjes
notjes's picture
User offline. Last seen 1 year 33 weeks ago. Offline
Joined: 06/17/2010
Posts: 2
Re: mission imposible

we have a file with 22636 rows where there is software in

 

i need to read a line copy that text into google then go automaticly to the first link in google and copy that link

lokesh
User offline. Last seen 9 weeks 4 days ago. Offline
Joined: 08/05/2010
Posts: 12
Re: mission imposible

I know how to do it because I spent the entire last day tweaking my regex for scraping google.

Attached the job. I don't close the second excel instance, you can save it accordingly.

 

The only thing that makes it impossible is google blocking you for too many queries.

Lokesh

AttachmentSize
Mission Impossible.waj 18 KB
134p
User offline. Last seen 1 year 25 weeks ago. Offline
Joined: 08/02/2010
Posts: 3
Re: mission imposible

 Well, if the too many queries are the problem, you can implement a waiting mechanism that will pause the job for say 5 minutes every 10 requests or so.