Delete rows with unique value for specific column Post: 302654825

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Print rows, having pattern in specific column...

Hello all, :) I have a pattern file some what like this, cd003 cd005 cd007 cd008 and input file like this, abc cd001 cd002 zca bca cd002 cd003 cza cba cd003 cd004 zca bac cd004 cd005 zac cba cd005 cd006 acz acb cd006 cd007 caz cab cd007 ...

2. UNIX for Dummies Questions & Answers

Delete all rows that contain a specific string (text)

Hi, I have a text file and I want to delete all rows that contain a particular string of characters. How do I go about doing that? Thanks!

3. Shell Programming and Scripting

Delete unique rows - optimize script

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

4. Shell Programming and Scripting

Print unique names in each row of a specific column using awk

Is it possible to remove redundant names in the 4th column? input cqWE 100 200 singapore;singapore AZO 300 400 brazil;america;germany;ireland;germany .... .... output cqWE 100 200 singapore AZO 300 400 brazil;america;germany;ireland

5. UNIX for Dummies Questions & Answers

Deleting rows where the value in a specific column match

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

6. Shell Programming and Scripting

Print unique names in a specific column using awk

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 ...

7. Shell Programming and Scripting

Converting Single Column into Multiple rows, but with strings to specific tab column

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...

8. Shell Programming and Scripting

Extract lines with unique value using a specific column

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. Shell Programming and Scripting

Count frequency of unique values in specific column

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...

10. UNIX for Dummies Questions & Answers

Removing rows that contain non-unique column entry

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...

LEARN ABOUT DEBIAN

shanty

SHANTY(1)							      Shanty								 SHANTY(1)

NAME

       Shanty - Makes a PostScript file from an image and some text.

SYNOPSIS

       shanty -i image_file [-t text_file] [-o output_file] [-s paper_size] [-d density] [-m margin] [-b background_color] [-x padding] [-n title]
       [-l orientation] [-rtl] [-btt] [-f font_name] [-altgd]

DESCRIPTION

       Shanty takes a text file and an image (PNG or JPG) and creates a PostScript file where one pixel in the image becomes one character in  the
       PostScript.

OPTIONS

       -i, -image
		 Name of the image to load in. JPG and PNG images are supported. This is the only compulsory field.

       -t, -text Name of the text file to load in, if omitted STDIN is used.

       -o, -output
		 Name of the PostScript file to produce, if omitted STDOUT is used.

       -s, -size Size  of  the	paper  to  work  with.	This  field  should be one of: "a0", "a2", "a3", "a4", "a5", "a6", "letter", "broadsheet",
		 "ledger", "tabloid", "legal", "executive" and "36x36". Default is "a4".

       -d, -density
		 Density of the text. Higher numbers are more dense, default is 1.4.

       -m, -margin
		 The margins of the page in cm. Default is 1.

       -b, -background
		 The colour of a backing rectangle to place behind the text. Colours are specified as "R,G,B" with each value between 0  and  255.
		 "off" means no backing colour. Default is "off".

       -x, -p, -padding
		 Density of the text. Higher numbers are more dense, default is 1.4.

       -n, -title
		 The title of the output to write as meta-data in the PostScript file. Default is "Shanty output".

       -l, -orientation
		 The orientation of the paper, can be "portrait", "landscape" or "auto". Default is "auto".

       -rtl	 Switch to right-to-left text.

       -btt	 Switch to bottom-to-top text.

       -f, -font Specify font. The font name specified must be visible to the not just make a font magically appear. Default is "Courier-Bold".

       -altgd	 If you have problems loading the GD library, try this switch.

HOMEPAGE

       <http://www.codebunny.org/coding/shanty/>

AUTHOR

       Duncan Martin <duncan@codebunny.org>

ACKNOWLEDGEMENTS

       Many thanks to DFB <http://www.cs.nott.ac.uk/~dfb/> and contributors to comp.lang.postscript.

Duncan Martin							  6 October 2006							 SHANTY(1)