Sort Unique Column with the most recent timestamp Post: 302958753

Sponsored Content

Top Forums Shell Programming and Scripting Sort Unique Column with the most recent timestamp Post 302958753 by rahul2662 on Monday 26th of October 2015 07:27:49 AM

10-26-2015

Registered User

Sort Unique Column with the most recent timestamp

Hello,

I have a sample file with the below contents :

Code:

Backup  Oracle8_P112_PEGA_Archivedel    Completed       full    10/11/2015 03:50:06PM
Backup  Oracle8_G567_PEGA_Archivedel    Completed       full    10/11/2015 01:15:56PM
Backup  Oracle8_P112_PEGA_Archivedel    Completed       full    10/11/2015 02:15:21PM
Backup  Oracle8_G567_PEGA_Archivedel    Completed       full    10/11/2015 03:15:17PM
Backup  Oracle8_P112_PEGA_Archivedel    Completed       full    10/11/2015 02:18:32PM

I want only those output records satisying both of the below cases ::::::

1) Unique values from Column 2nd
2) Most recent timestamp from column 5th/6th.

For example following should be the Output (we have selected Unique values from column 2nd and the record with most recent timestamp is the output ):

Code:

Backup  Oracle8_P112_PEGA_Archivedel    Completed       full    10/11/2015 03:50:06PM
Backup  Oracle8_G567_PEGA_Archivedel    Completed       full    10/11/2015 03:15:17PM

Could someone please help me with providing approach to proceed with this.

Thanks
Rahul

rahul2662

View Public Profile for rahul2662

Find all posts by rahul2662

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort and Unique in Perl

Hi, May I know, if a pipe separated File is large, what is the best method to calculate the unique row count of 3rd column and get a list of unique value of the 3rdcolum? Thanks in advance!

2. Shell Programming and Scripting

ksh scripting: Extract 1 most recent record for unique key

I'm loading multiple delimited files into an Oracle DB using sqlldr on Unix. I would like to get only the most recent record per each unique key. There may be multiple updates for each key, but I only want the most recent one. There is a date column in my delimited files, so I'm using cat to...

3. UNIX for Dummies Questions & Answers

sort biggest most recent files

if i am in /tmp file, and i have a few DIRs under /tmp. i want to find the biggest and most recent files (from 7 days ago) in /tmp and subfolders.

4. Shell Programming and Scripting

Awk sort and unique

5. Shell Programming and Scripting

sort a file of 5 online by taking only the most recent

Hello, i develop a shell unix program and i have a csv file. every time we have 5 identical lines in the first 3 columns in the fourth column can be different and the 5th too. In the 5th I have a date in yyyy / mm / dd. I want to do a sort on the 5 lines and keep only the line where there is the...

6. Shell Programming and Scripting

Unique sort with two fields

I have a file with contents below 123,502 123,506 123,702 234,101 235,104 456,104 456,100 i want to sort such that i get a unique value in column A, and for those with multiple value in A, i want the lowest value in B. output should be 123,502 234,101 235,104 456,100

7. Shell Programming and Scripting

Unique sort with three fields

I have another file with three columns A,B,C as below 123,1,502 123,2,506 123,3,702 234,4,101 235,5,104 456,6,104 456,7,100 i want to sort such that i get a unique value in column A, and for those with multiple value in A, i want the lowest value in C. output should be Code:...

8. UNIX for Dummies Questions & Answers

Print unique lines without sort or unique

I would like to print unique lines without sort or unique. Unfortunately the server I am working on does not have sort or unique. I have not been able to contact the administrator of the server to ask him to add it for several weeks.

9. Shell Programming and Scripting

Count occurrence of column one unique value having unique second column value

Hello Team, I need your help on the following: My input file a.txt is as below: 3330690|373846|108471 3330690|373846|108471 0640829|459725|100001 0640829|459725|100001 3330690|373847|108471 Here row 1 and row 2 of column 1 are identical but corresponding column 2 value are...

10. Shell Programming and Scripting

Sort unique

Hi, I have an input file that I have sorted in a previous stage by $1 and $4. I now need something that will take the first record from each group of data based on the key being $1 Input file 1000AAA|"ZZZ"|"Date"|"1"|"Y"|"ABC"|""|AA 1000AAA|"ZZZ"|"Date"|"2"|"Y"|"ABC"|""|AA...

LEARN ABOUT HPUX

bdb.db0

BDB.DB0(5)							AFS File Reference							BDB.DB0(5)

NAME

       bdb.DB0, bdb.DBSYS1 - Contain the Backup Database and associated log

DESCRIPTION

       The bdb.DB0 file contains the Backup Database, which records configuration information used by the AFS Backup System along with cross-
       indexed records of the tapes created and volumes dumped using the Backup System commands.

       The bdb.DBSYS1 file is a log file in which the Backup Server (buserver process) logs each database operation before performing it. When an
       operation is interrupted, the Backup Server replays the log to complete the operation.

       Both files are in binary format and reside in the /var/lib/openafs/db directory on each database server machine that runs the Backup
       Server.	When the Backup Server starts or restarts on a given machine, it establishes a connection with its peers and verifies that its
       copy of the bdb.DB0 file matches the copy on the other database server machines. If not, the Backup Servers use AFS's distributed database
       technology, Ubik, to distribute to all of the machines the copy of the database with the highest version number.

       Use the commands in the backup suite to administer the Backup Database. It is advisable to create a backup copy of the bdb.DB0 file on tape
       on a regular basis, using the UNIX tar command or another local disk backup utility.

SEE ALSO

       backup(8), backup_savedb(8), buserver(8)

COPYRIGHT

       IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.

       This documentation is covered by the IBM Public License Version 1.0.  It was converted from HTML to POD by software written by Chas
       Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.

OpenAFS 							    2012-03-26								BDB.DB0(5)