Results 1 to 2 of 2

Thread: VBS script to parse a directory of .csv files

  1. Jul 12th, 2016, 04:48 PM #1
    roxydogg
    roxydogg is offline

    Thread Starter
    Member
    Join Date
    Apr 2007
    Posts
    42

    VBS script to parse a directory of .csv files

    I have many directories of weather data containing lots of .csv files (hundreds of thousands) I developed a script that went through and changed a character in each filename of a particular type so that I could isolate particular files easier. Now I need to look in those files and pull out ONE field of data, I am looking for either the highest or lowest temperature on a given date.
    Typical data in the files looks like this

    #2015-01-31 03:00:04#,19.49

    I need to concentrate on the 19.49 field. Only 2 fields in these particular files.

    Thanks to all
    Reply With Quote Reply With Quote
  2. Jul 13th, 2016, 01:48 AM #2
    FunkyDexter
    FunkyDexter is offline
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    7,957

    Re: VBS script to parse a directory of .csv files

    Moved to VBScript Forum
    The best argument against democracy is a five minute conversation with the average voter - Winston Churchill

    Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width