1234|1|Jon|some text|some text
1234|2|Jon|some text|some text
3453|5|Jon|some text|some text
6533|2|Kate|some text|some text
4567|3|Chris|some text|some text
4567|4|Maggie|some text|some text
8764|6|Maggie|some text|some text
My third column is my KEY and I want to only print lines of the file if the KEY has been printed more than once. So basically any unique entry for column three can be deleted.
Code:
So the output would look like this
1234|1|Jon|some text|some text
1234|2|Jon|some text|some text
3453|5|Jon|some text|some text
4567|4|Maggie|some text|some text
8764|6|Maggie|some text|some text
Can you please help me?
Moderator's Comments:
Please use [code]...[/code] tags instead of [quote]...[/quote] tags for code and samples
Last edited by Scrutinizer; 06-11-2012 at 12:59 AM..
Reason: code tags instead of code tags
Hi all,
I have the following input - the unique row key is 1st column
cat file.txt
A response
C request
C response
D request
C request
C response
E request
The desired output should be
C request (7 Replies)
Hi,
I have a tab delimited text file where I want to delete all rows that have the same string for column 1. How do I go about doing that? Thanks!
Example Input:
aa 1
aa 2
aa 3
bb 4
bc 5
bb 6
cd 8
Output:
bc 5
cd 8 (4 Replies)
Is it possible to modify file like this.
1. Remove all the duplicate names in a define column i.e 4th col
2. Count the no.of unique names separated by ";" and print as a 5th col
thanx in advance!!
Q
input
c1 30 3 Eh2
c10 96 3 Frp
c41 396 3 Ua5;Lop;Kol;Kol
c62 2 30 Fmp;Fmp;Fmp
... (5 Replies)
Dear fellows, I need your help.
I'm trying to write a script to convert a single column into multiple rows.
But it need to recognize the beginning of the string and set it to its specific Column number.
Each Line (loop) begins with digit (RANGE).
At this moment it's kind of working, but it... (6 Replies)
Hi there,
I need a help with extracting data from tab delimited file which look like this
#CHROM POS ID REF ALT Human Cow Dog Mouse Lizard
chr2 3033 . G C 0/0 0/0 0/0 1/1 0/0
chr3 35040 . G T 0/0 0/0 ./. 1/1 0/1
chr4 60584 . T G 1/1 1/1 0/1 1/1 0/0
chr10 7147815 . G A 0/0 1/1 0/0 0/0... (9 Replies)
Hi, I have tab-deliminated data similar to the following:
dot is-big 2
dot is-round 3
dot is-gray 4
cat is-big 3
hot in-summer 5
I want to count the frequency of each individual "unique" value in the 1st column. Thus, the desired output would be as follows:
dot 3
cat 1
hot 1
is... (5 Replies)
Background:
I have a file of thousands of potential SSR primers from Batch Primer 3.
I can't use primers that will contain the same sequence ID or sequence as another primer.
I have some basic shell scripting skills, but not enough to handle this.
What you need to know:
I need to remove the... (1 Reply)
Discussion started by: msatseqs
1 Replies
LEARN ABOUT OSF1
dxmcstextgetselection
DXmCSTextGetSelection(3X)DXmCSTextGetSelection(3X)NAME
DXmCSTextGetSelection - Retrieves the text selected in the compound string text widget.
SYNOPSIS
XmString DXmCSTextGetSelection(
Widget widget );
PARAMETERS
The identifier (widget ID) of the compound string text widget.
DESCRIPTION
The DXmCSTextGetSelection routine retrieves the text selected (highlighted) in the compound string text widget. It returns a Null pointer
if no text is selected in the widget. The application is responsible for freeing the storage associated with the text by calling the
Intrinsic routine XtStringFree.
RETURN VALUES
A pointer to the selected text compound string.
SEE ALSO DXmCreateCSText(3X), DXmCSTextClearSelection(3X), DXmCSTextCopy(3X), DXmCSTextCut(3X), DXmCSTextPaste(3X), DXmCSTextSetSelection(3X)DXmCSTextGetSelection(3X)
06-10-2012
Delete rows with unique value for specific column
