work with url

teresaOP has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I´m new so sorry in advance!!!. My problem is simple I am a Biochemist and I´ve been using perl for processing text files for a little while now. Yesterday I run into a problem I have to make at least 60 queries to a given database for extracting some info. somebody could tell me how can I perform these queries automatically for saving time. I´ve been reading about this topic but there are so many answers that i got confused. Also I would like to perform the query and download the results in a cvs file using the download option at the page. If this possible I mean can I do this in a simple way. I need help.... Thanks for reading until here.

Comment on work with url

Replies are listed 'Best First'.
Re: work with url by BrowserUk (Patriarch) on Mar 12, 2014 at 20:30 UTC
Put the urls in a file one per line then use `wget -i theFile`. With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday' Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error. "Science is about questioning the status quo. Questioning authority". In the absence of evidence, opinion is indistinguishable from prejudice.	[reply] [d/l]
Re^2: work with url by teresaOP (Initiate) on Mar 13, 2014 at 12:50 UTC
Thanks!!! I must admit that I wrote the question fast cause I had a work meeting and I didn´t describe what i wanted in detail. I have to find a way that allows me to fill a search box over and over with information extracted , lets say from column in a text file and then retrieve the obtained result in a csv file using the option given by the result page. Thanks again	[reply]
Re: work with url by locked_user sundialsvc4 (Abbot) on Mar 13, 2014 at 14:54 UTC
Actually, maybe you can do this within a spreadsheet, by defining the database-query as a data source. In some cases, the spreadsheet will issue the repeated queries for you in order to produce the results you need, as it resolves the spreadsheet. Writing a short function in a built-in scripting language (e.g. Visual Basic) is also a possibility. Carefully review the database-querying capabilities (and associated examples) in the spreadsheet and/or data analysis tools that you are using. Perhaps the use of Perl (or any outside language/script), in this case, can be avoided.