[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

Extract data from a webpage in to csv file or excel

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
amankhan2005
Asked:
amankhan2005
1 Solution
 
aikimarkCommented:
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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now