Hi all
I have a file which looks like this
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.
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 X11R4
urlcoding
URLCODING(3) libbash urlcoding Library Manual URLCODING(3)NAME
urlcoding -- a Libbash library for encoding and decoding URL's.
SYNOPSIS
urlEncodeString [-l] <STRING>
urlEncodeFile [-l] <FILE>
urlEncodeStream [-l]
urlDecodeString <STRING>
urlDecodeFile <FILENAME>
urlDecodeStream
DESCRIPTION
urlcoding is a collection of functions that convert ASCII-text to standard URL's and vice-versa. The AWK code used is based on code by Heiner
Steven <heiner.steven@odn.de>
The function list:
urlEncodeString Creates a URL from an ASCII string
urlEncodeFile Converts a file into URL-valid text
urlEncodeStream Converts standard input into URL-valid text
urlDecodeString Converts a URL-encoded text back to a plain-text form
urlDecodeFile Coverts URL-encoded text in a file back to plain text
urlDecodeStream Converts URL-encoded standard input to text
Detailed interface description follows.
The [-l] option for the encoding functions should be used when line-feed characters ('
') are to be encoded as well.
All functions print the results of their conversions to standard output.
The exit status of all functions is that of the command 'awk', with '0' for success
FUNCTIONS DESCRIPTIONS
urlEncodeString [-l] <STRING>
Converts STRING - a string of ASCII characters - to URL.
urlEncodeFile [-l] <FILE>
Coverts FILE of URL-encoded text to plain text
urlEncodeStream [-l]
Converts text from standard input to URL-text.
urlDecodeString <STRING>
Converts URL-encoded string STRING back to text.
urlDecodeFile <FILENAME>
Converts the URL-encoded text in FILE to plain text.
urlDecodeStream
Converts the URL-encoded text from standard input to plain-text
AUTHORS
Alon Keren <alon.keren@gmail.com>
SEE ALSO ldbash(1), libbash(1)Linux Epoch Linux