RudiC already told you that that script would only work if all of the times for a given field 1 were on the same date. We would hope that you would have used his suggestion as a starting point and would have figured out how to extend it to work with multiple dates.
Since your sample data was all on one day, testing for anything else is just guess work. (I'm guessing that the sample data you provided is for May 8, 2015; not August 5, 2015. If I guessed incorrectly, you'll have to modify the sort to make the month a higher order sort key than the day.)
The following produces the correct sets of lines for you, but the order of the sets of lines is different than in your sample. You didn't specify any order for the output other than that the records selected of output had to be the most recent date and time for each key value. If you want a specific order for the keys, you should have said what that order should be. Try:
This User Gave Thanks to Don Cragun For This Post:
I'm a new member of the forum, I had this new generate file since I use 'grep' and 'awk', what I want to do is get rid off the all 0s before the numbers, is there any one who could help me to figure it out? Thanks a lot!
yun
0000000029 000q7472 2002/03/01
0000000030 000q7472 2002/03/01
... (2 Replies)
Hello,
I got this question which tells me to customize my login script. Some people in the forums suggested to modify the .profile file in my home directory. I did so, but none of my customizations show up when I open the terminal after.
So, I tried to modify other files in my home directory,... (1 Reply)
Hi all
Can anyone suggest me a good solution ? My requirement is as follows
I have a plain text file similar to this...
sending data to 0003345234
here is the output...
,..........
...........
.......
sending data to 00033452ab
here is the output...
,..........
...........
.... (5 Replies)
Hi All,
I have a file like below, how can i insert one line after line 1 without using a temporary file in perl?
line 1
line 2
line 3
expected result
line 1
new line <---insert here
line 2
line 3 (2 Replies)
Hi,
I have a file that looks like this:
27+:<10,289808,1>
31+:<11,1445372,1>
33-:<7,1014101,2>
35+:<11,728811,1>
36-:<11,1445205,0>
37+:<11,1445792,2>
and I want to change it to this:
+ 10 289808
+ 11 1445372
- 7 1014101
+ 11 728811
- 11 1445205
+ 11 1445792 (3 Replies)
hello,
I have problem with writing/adjusting a shell script.
I searched forum and unfortunately couldn't write scipt based on the information I found.
I never wtire such so it's hard for me and I do need to modify one script immediately.
case looks like:
1. 'file' that needs to be modified... (3 Replies)
Hi, I would like to change my CSV file by adding " and : and moving some of the information around. the CSV file looks as follows:
501254424;500440257;PE PACKS;300467279;PREP;;276476070;655031001867176;Two Block;Olga;25/12/2015 00:00:00;Olga
I would like to move the field 7 to the front "... (13 Replies)
Running Oracle Linux 6 (derivative of RHEL 6)
Given this snippet of code in a shell script:
#-- reset oratab to use 11.2 home for dwdev
#-- normally we'd just use sed to do this sort of thing, but that would
#-- require permissions that we don't have in the /etc/ directory, so we
#-- ... (3 Replies)