05-06-2009
Help with Uniq and sort
The key is first field i want only uniq record for the first field in file.
Quote:
FileA
ABC,hello,world
ABC,hello,america
XYZ,god,bless
INJ,are,youthere
I want the output as
Quote:
ABC,hello,america
XYZ,god,bless
INJ,are,youthere
or output as
Quote:
ABC,hello,world
XYZ,god,bless
INJ,are,youthere
Appreciate help on this
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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
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
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
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
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
6. Shell Programming and Scripting
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.
... (1 Reply)
Discussion started by: nua7
1 Replies
7. Shell Programming and Scripting
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
Hi again,
I have files with the following contents
datetime,ip1,port1,ip2,port2,number
How would I find out how many times ip1 field shows up a particular file? Then how would I find out how many time ip1 and port 2 shows up?
Please mind the file may contain 100k lines. (8 Replies)
Discussion started by: LDHB2012
8 Replies
9. UNIX for Dummies Questions & Answers
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
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
LEARN ABOUT REDHAT
kas_stringtokey
KAS_STRINGTOKEY(8) AFS Command Reference KAS_STRINGTOKEY(8)
NAME
kas_stringtokey - Converts a character string into an octal key
SYNOPSIS
kas stringtokey -string <password string>
[-cell <cell name>] [-help]
kas str -s <password string> [-c <cell name>] [-h]
DESCRIPTION
The kas stringtokey command converts the character string specified with the -string argument into an octal string suitable for use as an
encryption key.
The kas command interpreter generates the octal key by using an encryption algorithm on the combination of the specified string and the
name of the local cell (as recorded in the local /etc/openafs/ThisCell file). Use the -cell argument to convert a string into a key
appropriate for a cell other than the local one.
CAUTIONS
This command writes the key to the standard output stream, on which it can possibly be intercepted by third parties. It is not very secure
to use the key in an actual Authentication Database entry.
OPTIONS
-string <password string>
Specifies the character string to convert into an octal key.
-cell <cell name>
Specifies the complete Internet domain name of the cell to combine with the password string while generating the key. If this argument
is omitted, the kas command interpreter determines the name of the local cell by consulting:
o First, the value of the environment variable AFSCELL.
o Second, the cellname in the /etc/openafs/ThisCell file on the local machine.
-help
Prints the online help for this command. All other valid options are ignored.
OUTPUT
The output is of the following form:
Converting I<password string> in realm 'I<cell_name>' yields key='I<key>'.
EXAMPLES
The following example shows the octal key equivalent of the string "new_pswd" in the ABC Corporation cell.
% kas stringtokey new_pswd
Converting new_pswd in realm 'ABC.COM' yields
key='346307364320263233342354'.
PRIVILEGE REQUIRED
None, and no password is required.
SEE ALSO
ThisCell(5), kas(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 KAS_STRINGTOKEY(8)