Results 1 to 3 of 3

Thread: newbie needs help....sort timefield in a text file

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2000
    Posts
    3

    Lightbulb

    I have a comma delimited text file and want to sort by the 4th column which is in 24hr format. Any ideas on the easiest way to do this. The single digit times do not have leading zero's. ex. 7:00:00 instead of 07:00:00.

    Thanks in advanced!!!!
    Kelly Mills

  2. #2
    Lively Member
    Join Date
    Oct 2000
    Location
    Chicago
    Posts
    97
    Sorry didn't get you properly.If you can give what exactly you want then i can try to help you.Give the piece of code as what you want to do and i will work on it..
    Anil

  3. #3

    Thread Starter
    New Member
    Join Date
    Jun 2000
    Posts
    3

    sort time stamp log sample

    here is an example of the text line

    208.202.148.38, -, 9/3/00, 22:12:28, TNT01, MY_WEB, 10.20.10.137, 0, 230, 604, 404, 2, GET, /robots.txt, -,

    I am creating one file from a handfull of other files that contain similar lines as that above. Once I create the new file I need to sort by the 4th column (time stamp). I did this really easy with awk and sort on my solaris box, but would like to do it with vb since it will be running on an NT machine.

    Thanks again
    Kelly

Posting Permissions

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



Click Here to Expand Forum to Full Width