Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


download, unzip & compare CSV files

  		Logged in as: Guest
arrSession:exec spGetSession 2,2,3240
Active Users: There are 0 members and 0 guests.
Users viewing this topic: none
 

 

  
 
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> download, unzip & compare CSV files
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks! 		Page: [1]
Login
Message << Older Topic   Newer Topic >>
download, unzip & compare CSV files - 6/5/2005 12:30:58 PM   
  xya

 

Posts: 2
Score: 0
Joined: 6/5/2005
From:
Status: offline 		Hi,

I'm new to VB Scripts and I'm trying to download a CSV file, unzip it and compare it to another CSV file (earlier version).

I've got the script to download and unzip the file, and I'm trying to automate the download & unzip procedure by adding it into the Windows Scheduled Task. The only problem is when the unzipped file is the same as an existing file. How could I set it to overwrite the existing file?

Next, I am hoping to compare the downloaded CSV file with an earlier version of the CSV file in the same directory. I can't think of a better option than to execute an Excel application to read in data from both files and make the comparison, but it does seemed less efficient. Any ideas?

Thanks!
 
 
Post #: 1
 
Re: download, unzip & compare CSV files - 6/5/2005 3:09:19 PM   
  TNO


Posts: 1302
Score: 12
Joined: 12/18/2004
From: thenewobjective.com
Status: offline 		What do you have thus far code-wise? What are you using to unzip the file? WINZIP, WINRAR, PKZIP?

(in reply to xya)
 
 
Post #: 2
 
Re: download, unzip & compare CSV files - 6/5/2005 5:19:15 PM   
  xya

 

Posts: 2
Score: 0
Joined: 6/5/2005
From:
Status: offline 		I'm using this code to unzip:

cmd = UNZIP & " " & zippath & " -d " & destpath
UnZipFile = runCommand (cmd)

(in reply to xya)
 
 
Post #: 3
 
 
 
 

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> download, unzip & compare CSV files Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 ANSI