|
-
Oct 27th, 2000, 01:10 PM
#1
Thread Starter
New Member
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
-
Oct 27th, 2000, 01:16 PM
#2
Lively Member
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..
-
Oct 27th, 2000, 02:09 PM
#3
Thread Starter
New Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|