Sponsored Content
Top Forums Shell Programming and Scripting Sort and uniq after comparision Post 302728239 by nua7 on Wednesday 7th of November 2012 01:49:36 PM
Old 11-07-2012
Sort and uniq after comparision

Hi All,
I have a text file with the format shown below. Some of the records are duplicated with the only exception being date (Field 15). I want to compare all duplicate records using subscriber number (field 7) and keep only those records with greater date.

Code:
462|025249216A|JOANNE|LAMOTHE|19320825|F|S00287541|1221 CAMBRIDGE ST APT 808||CAMBRIDGE|MA|021391349|6176611866|MR|20120701|20120731|11072012|M
462|011328621A|JAMES|ST CROIX|19420929|M|S00751109|50 POCAHONTAS DR||PLYMOUTH|MA|02360|9787602758|MR|20120101|20120531|11072012|A
T0005|033164662D|VICTORIA|CIARLONE|19340427|F|S00844809|10 KIMBALL DR||STONEHAM|MA|02180|7814384583|MR|20120301||11072012|A
T0005|033164662D|VICTORIA|CIARLONE|19340427|F|S00844809|10 KIMBALL DR||STONEHAM|MA|02180|7814384583|MR|20120101|20120229|11072012|A
T0005|069163277A|MAX|POTASH|19201116|M|S00845432|20 LAUREL RD||SWAMPSCOTT|MA|01907|7815954792|MR|20120301||11072012|A
T0005|069163277A|MAX|POTASH|19201116|M|S00845432|20 LAUREL RD||SWAMPSCOTT|MA|01907|7815954792|MR|20120101|20120229|11072012|A
3|014408396A|PAUL|DECOLLIBUS|19490223|M|S00851755|129 HERITAGE WAY||HOLLISTON|MA|01746|5084291095|MR|20120601||11072012|A

Desired output :

Code:
462|025249216A|JOANNE|LAMOTHE|19320825|F|S00287541|1221 CAMBRIDGE ST APT 808||CAMBRIDGE|MA|021391349|6176611866|MR|20120701|20120731|11072012|M
462|011328621A|JAMES|ST CROIX|19420929|M|S00751109|50 POCAHONTAS DR||PLYMOUTH|MA|02360|9787602758|MR|20120101|20120531|11072012|A
T0005|033164662D|VICTORIA|CIARLONE|19340427|F|S00844809|10 KIMBALL DR||STONEHAM|MA|02180|7814384583|MR|20120301||11072012|A
T0005|069163277A|MAX|POTASH|19201116|M|S00845432|20 LAUREL RD||SWAMPSCOTT|MA|01907|7815954792|MR|20120301||11072012|A
3|014408396A|PAUL|DECOLLIBUS|19490223|M|S00851755|129 HERITAGE WAY||HOLLISTON|MA|01746|5084291095|MR|20120601||11072012|A

Any ideas will be appreciated!
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

sort/uniq

I have a file: Fred Fred Fred Jim Fred Jim Jim If sort is executed on the listed file, shouldn't the output be?: Fred Fred Fred Fred Jim Jim Jim (3 Replies)
Discussion started by: jimmyflip
3 Replies

2. UNIX for Dummies Questions & Answers

Help with Last,uniq, sort and cut

Using the last, uniq, sort and cut commands, determine how many times the different users have logged in. I know how to use the last command and cut command... i came up with last | cut -f1 -d" " | uniq i dont know if this is right, can someone please help me... thanks (1 Reply)
Discussion started by: jay1228
1 Replies

3. Shell Programming and Scripting

sort and uniq in perl

Does anyone have a quick and dirty way of performing a sort and uniq in perl? How an array with data like: this is bkupArr BOLADVICE_VN this is bkupArr MLT6800PROD2A this is bkupArr MLT6800PROD2A this is bkupArr BOLADVICE_VN_7YR this is bkupArr MLT6800PROD2A I want to sort it... (4 Replies)
Discussion started by: reggiej
4 Replies

4. Shell Programming and Scripting

Sort, Uniq, Duplicates

Input File is : ------------- 25060008,0040,03, 25136437,0030,03, 25069457,0040,02, 80303438,0014,03,1st 80321837,0009,03,1st 80321977,0009,03,1st 80341345,0007,03,1st 84176527,0047,03,1st 84176527,0047,03, 20000735,0018,03,1st 25060008,0040,03, I am using the following in the script... (5 Replies)
Discussion started by: Amruta Pitkar
5 Replies

5. Shell Programming and Scripting

Help with Uniq and sort

The key is first field i want only uniq record for the first field in file. I want the output as or output as Appreciate help on this (4 Replies)
Discussion started by: pinnacle
4 Replies

6. Shell Programming and Scripting

sort | uniq question

Hello, I have a large data file: 1234 8888 bbb 2745 8888 bbb 9489 8888 bbb 1234 8888 aaa 4838 8888 aaa 3977 8888 aaa I need to remove duplicate lines (where the first column is the duplicate). I have been using: sort file.txt | uniq -w4 > newfile.txt However, it seems to keep the... (11 Replies)
Discussion started by: palex
11 Replies

7. Shell Programming and Scripting

Sort field and uniq

I have a flatfile A.txt 2012/12/04 14:06:07 |trees|Boards 2, 3|denver|mekong|mekong12 2012/12/04 17:07:22 |trees|Boards 2, 3|denver|mekong|mekong12 2012/12/04 17:13:27 |trees|Boards 2, 3|denver|mekong|mekong12 2012/12/04 14:07:39 |rain|Boards 1|tampa|merced|merced11 How do i sort and get... (3 Replies)
Discussion started by: sabercats
3 Replies

8. Shell Programming and Scripting

Uniq or sort -u or similar only between { }

Hi ! I am trying to remove doubbled entrys in a textfile only between delimiters. Like that example but i dont know how to do that with sort or similar. input: { aaa aaa } { aaa aaa } output: { aaa } { (8 Replies)
Discussion started by: fugitivus
8 Replies

9. UNIX for Dummies Questions & Answers

Uniq and sort -u

Hello all, Need to pick your brains, I have a 10Gb file where each row is a name, I am expecting about 50 names in total. So there are a lot of repetitions in clusters. So I want to do a sort -u file Will it be considerably faster or slower to use a uniq before piping it to sort... (3 Replies)
Discussion started by: senhia83
3 Replies

10. Shell Programming and Scripting

Sort & Uniq -u

Hi All, Below the actual file which i like to sort and Uniq -u /opt/oracle/work/Antony/Shell_Script> cat emp.1st 2233|a.k. shukula |g.m. |sales |12/12/52 |6000 1006|chanchal singhvi |director |sales |03/09/38 |6700... (8 Replies)
Discussion started by: Antony Ankrose
8 Replies
acctcms(1M)															       acctcms(1M)

NAME
acctcms - command summary from per-process accounting records SYNOPSIS
[options] files DESCRIPTION
reads one or more files, normally in the form described in acct(4). It adds all records for processes that executed identically-named com- mands, sorts them, and writes them to the standard output, normally using an internal summary format. Options recognizes the following options: Print output in ASCII rather than in the internal summary format. The output includes command name, number of times executed, total kcore- minutes, total CPU minutes, total real minutes, mean size (in K), mean CPU minutes per invocation, ``hog factor'', charac- ters transferred, and blocks read and written, as in acctcom(1M). Output is normally sorted by total kcore-minutes. Sort by total CPU time, rather than total kcore-minutes. Combine all commands invoked only once under Sort by number of command invocations. Any file names encountered hereafter are already in internal summary format. Process all records as total accounting records. The default internal summary format splits each field into prime- and non-prime-time parts. This option combines the prime and non-prime time parts into a single field that is the total of both, and provides upward compatibility with old (i.e., UNIX System V) style internal summary format records. The following options can be used only with the option. Output a prime-time-only command summary. Output a non-prime- (offshift) time only command summary. When and are used together, a combination prime and non-prime time report is produced. All the output summaries are total usage except number of times executed, CPU minutes, and real minutes which are split into prime and non-prime. EXAMPLES
A typical sequence for performing daily command accounting and for maintaining a running total is: WARNINGS
Unpredictable output results if is used on new-style internal-summary-format files, or if it is not used with old style internal summary format files. The process mean memory size may overflow for values greater than SEE ALSO
acct(1M), acctcom(1M), acctcon(1M), acctmerg(1M), acctprc(1M), acctsh(1M), fwtmp(1M), runacct(1M), acct(2), acct(4), utmp(4). STANDARDS CONFORMANCE
acctcms(1M)
All times are GMT -4. The time now is 03:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy