05-06-2008
duplicates lines with one column different
Do any one have answer for my question ?
Regards
Dhana
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Input:
a
b
b
c
d
d
I need:
a
c
I know how to get this (the lines that have duplicates) :
b
d
sort file | uniq -d
But i need opossite of this. I have searched the forum and other places as well, but have found solution for everything except this variant of the problem. (3 Replies)
Discussion started by: necroman08
3 Replies
2. Shell Programming and Scripting
I have my data something like this
(08/03/2009 22:57:42.414)(:) king aaaaaaaaaaaaaaaa bbbbbbbbbbbbbbbbbbbbbb
(08/03/2009 22:57:42.416)(:) John cccccccccccc cccccvssssssssss baaaaa
(08/03/2009 22:57:42.417)(:) Michael ddddddd tststststtststts
(08/03/2009 22:57:42.425)(:) Ravi... (11 Replies)
Discussion started by: rdhanek
11 Replies
3. Shell Programming and Scripting
Hi All,
i need ti delete two duplicate processss which are running on the same device type (column 1) and port ID (column 2). here is the sample data
p1sc1m1 15517 11325 0 01:00:24 ? 0:00 scagntclsx25octtcp 2967 in3v mvmp01 0 8000 N S 969 750@751@752@
p1sc1m1 15519 11325 0 01:00:24 ? ... (5 Replies)
Discussion started by: neeraj617
5 Replies
4. Shell Programming and Scripting
Given a file such as this I need to remove the duplicates.
00060011 PAUL BOWSTEIN ad_waq3_921_20100826_010517.txt
00060011 PAUL BOWSTEIN ad_waq3_921_20100827_010528.txt
0624-01 RUT CORPORATION ad_sade3_10_20100827_010528.txt
0624-01 RUT CORPORATION ... (13 Replies)
Discussion started by: script_op2a
13 Replies
5. Shell Programming and Scripting
Hi all,
I have an input file like this
Now
I have to remove duplicates only in first column and nothing has to be changed in second and third column. so that output would be
Please let me know scripting regarding this (20 Replies)
Discussion started by: manigrover
20 Replies
6. Shell Programming and Scripting
Hi,
I have a file (sorted by sort) with 8 tab delimited columns. The first column contains duplicated fields and I need to merge all these identical lines.
My input file:
comp100002 aaa bbb ccc ddd eee fff ggg
comp100003 aba aba aba aba aba aba aba
comp100003 fff fff fff fff fff fff fff... (5 Replies)
Discussion started by: falcox
5 Replies
7. Shell Programming and Scripting
Hi all,
I have huge a tab-delimited file with the following format and I want to remove the duplicates according to their frequency based on Column2 and Column3.
Column1 Column2 Column3 Column4 Column5 Column6 Column7
1 user1 access1 word word 3 2
2 user2 access2 ... (10 Replies)
Discussion started by: corfuitl
10 Replies
8. Shell Programming and Scripting
Dear All,
I really enjoy your help or suggestion for resolving an issue.
Briefly, I have a file like this:
a b c
a d e
f g h
k g h
x y z
If the first column has the same ID, for example a, just remove it.
The output should be this:
f g h
k g h
x y z
I was thinking to do it... (11 Replies)
Discussion started by: giuliangiuseppe
11 Replies
9. Shell Programming and Scripting
Hi folks,
I've got a csv file called test.csv
Column A Column B
Apples 1900
Apples 1901
Pears 1902
Pears 1903I want to count and keep duplicates in the first column. Desired output
Column A Column B Column C
Apples 2 1900
Apples ... (5 Replies)
Discussion started by: pshields1984
5 Replies
10. Shell Programming and Scripting
Hi Experts,
Please bear with me, i need help
I am learning AWk and stuck up in one issue.
First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique.
Second point : For... (1 Reply)
Discussion started by: as7951
1 Replies
QUIZ(6) BSD Games Manual QUIZ(6)
NAME
quiz -- random knowledge tests
SYNOPSIS
quiz [-t] [-i file] [question answer]
DESCRIPTION
The quiz utility tests your knowledge of random facts. It has a database of subjects from which you can choose. With no arguments, quiz
displays the list of available subjects.
The options are as follows:
-t Use tutorial mode, in which questions are repeated later if you didn't get them right the first time, and new questions are presented
less frequently to help you learn the older ones.
-i Specify an alternative index file.
Subjects are divided into categories. You can pick any two categories from the same subject. quiz will ask questions from the first cate-
gory and it expects answers from the second category. For example, the command ``quiz victim killer'' asks questions which are the names of
victims, and expects you to answer with the cause of their untimely demise, whereas the command ``quiz killer victim'' works the other way
around.
If you get the answer wrong, quiz lets you try again. To see the right answer, enter a blank line.
Index and Data File Syntax
The index and data files have a similar syntax. Lines in them consist of several categories separated by colons. The categories are regular
expressions formed using the following meta-characters:
pat|pat alternative patterns
{pat} optional pattern
[pat] delimiters, as in pat[pat|pat]pat
In an index file, each line represents a subject. The first category in each subject is the pathname of the data file for the subject. The
remaining categories are regular expressions for the titles of each category in the subject.
In data files, each line represents a question/answer set. Each category is the information for the question/answer for that category.
The backslash character (``'') is used to quote syntactically significant characters, or at the end of a line to signify that a continuation
line follows.
If either a question or its answer is empty, quiz will refrain from asking it.
FILES
/usr/share/games/quiz The default index and data files.
BUGS
quiz is pretty cynical about certain subjects.
BSD
May 31, 1993 BSD