Solved

Extract data from a webpage in to csv file or excel

Posted on 2013-01-21
1
302 Views
Last Modified: 2013-02-12
Hi all,

  I want to extract currency info from a weblink in to csv file using a shell script...

  Please find below attached file for more details.

Thanks
Aman
extract-values.doc
0
Comment
Question by:amankhan2005
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 45

Accepted Solution

by:
aikimark earned 500 total points
ID: 38807296
If you know the date, then you do not need to traverse the archive.  The results are stored in individual documents.

So, 2013-01-02 would be in this URL:
http://www.tcmb.gov.tr/kurlar/201301/02012013.html

The normal way to retrieve such content is to instantiate a variable with
= createobject("InternetExplorer.Application")
Reference: http://msdn.microsoft.com/en-us/library/aa752084(v=vs.85).aspx

The next part of your requirement is to render this in CSV format.  It would be helpful if you used the content of the URL above and manually rendered it as CSV.  That will give the experts some idea of the transform you have in mind.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question