Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: help! script to select line with greatest value 2 between columns
Top Forums UNIX for Dummies Questions & Answers help! script to select line with greatest value 2 between columns Post 302566737 by ctsgnb on Friday 21st of October 2011 03:26:21 AM
Old 10-21-2011
... for we it works :
Code:
$ cat tst.txt
gene accession chr chr_st begin end length
NN1 NC_024540 chr3 - 14000 14020
NN1 NC_024543 chr3 - 14010 14060
NN1 NC_024543 chr3 - 14050 14060
ATG NC_01 chr12 + 12000 12100
ATG NC_02 chr12 + 12100 12900
ATG NC_02 chr12 + 12100 12300

Code:
$ nawk 'NR<2{next}{c=($NF-$(NF-1))}(!($1 in A))||(c>m[$1]&&($1 in A)){m[$1]=c;A[$1]=$0 FS m[$1]}END{for(i in A) print A[i]}' tst.txt
NN1 NC_024543 chr3 - 14010 14060 50
ATG NC_02 chr12 + 12100 12900 800

Please upload your entire input file also provide the output you get as well as the command you ran (make sure you didn't forget any parenthesis).
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Select and display sum depending upon even columns

i have a input as : 2898 | homy | pune | 7/4/09 1 :6298 | anna | chennai | 7/4/08 2 :3728 | gonna | kol | 8/2/10 3 :3987 | hogja | mumbai | 8/5/09 4 :6187 | galma | london | 9/5/01 5 :9167 | tamina | ny | 8/3/10 6 :3981 | dastan | bagh | 8/2/07 7 :4617 | vazir | ny now,i want to get... (2 Replies)
Discussion started by: adityamitra
2 Replies

2. Shell Programming and Scripting

Select and display sum depending upon even columns

Select and display sum depending upon even columns i have a input as : 2898 | homy | pune | 7/4/09 1 :6298 | anna | chennai | 7/4/08 2 :3728 | gonna | kol | 8/2/10 3 :3987 | hogja | mumbai | 8/5/09 4 :6187 | galma | london | 9/5/01 5 :9167 | tamina | ny | 8/3/10 6 :3981 | dastan | bagh |... (1 Reply)
Discussion started by: adityamitra
1 Replies

3. Shell Programming and Scripting

[Solved] Select the columns which have value greater than particular number

i have a file of the form 9488 14392 1 1.8586e-07 5702 7729 1 1.8586e-07 9048 14018 1 1.8586e-07 5992 12556 1 1.8586e-07 9488 14393 1 1.8586e-07 9048 14019 1 1.8586e-07 5992 12557 1 1.8586e-07 9488 14394 ... (1 Reply)
Discussion started by: vaibhavkorde
1 Replies

4. Shell Programming and Scripting

Select columns from a matrix given within a range in BASH

I have a huge matrix file which looks like this (example matrix): 1 2 3 5 4 5 6 7 7 6 8 9 1 2 4 2 7 6 5 1 3 2 1 9 As one can see, this matrix has 4 columns and 6 rows. But my original matrix has some 3 million rows and 6000 columns. For example, on this matrix I can define my task as... (2 Replies)
Discussion started by: shoaibjameel123
2 Replies

5. Shell Programming and Scripting

Select lines where at least x columns above threshold value

I have a file with 20 columns. I'd like to retain only the lines for which the values in at least x columns, looking only at columns 6-20, are above a threshold. For example, I'd like to retain only the lines in the file below that have at least 8 columns (again, looking only at columns 6-20)... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

6. Shell Programming and Scripting

Take greatest value from second column

Dear All, Please help me, I have file input like this, 1 2142 215 2162 217 2842 285 2862 287 4002 401 4022 403 4822 1 2142 215 2162 217 2842 285 2862 287 4002 401 4022 403 4882 1 4801 (8 Replies)
Discussion started by: attila
8 Replies

7. Shell Programming and Scripting

Comparing Select Columns from two CSV files in UNIX and create a third file based on comparision

Hi , I want to compare first 3 columns of File A and File B and create a new file File C which will have all rows from File B and will include rows that are present in File A and not in File B based on First 3 column comparison. Thanks in advance for your help. File A A,B,C,45,46... (2 Replies)
Discussion started by: ady_koolz
2 Replies

8. Shell Programming and Scripting

Select all the even columns from a file

Hi, I can select all the even columns from a file like this: awk '{ for (i=1;i<=NF;i+=2) $i="" }1' file > new file How can I select the 1st and all the even columns using awk? Thanks! (1 Reply)
Discussion started by: forU
1 Replies

9. Shell Programming and Scripting

How do I select certain columns with matching pattern and rest of the lines?

I want to select 2nd, 3rd columns if line has "key3" and print rest of the lines as is. # This is my sample input key1="val1" key2="val2" key3="val3" key4="val4" some text some text some text some text key1="val1" key2="val2" key3="val3" key4="val4" some text some text some text some... (3 Replies)
Discussion started by: kchinnam
3 Replies

10. UNIX for Beginners Questions & Answers

How to select rows that have opposite values (A vs B, or B vs A) on first two columns?

I have a dateset like this: Gly1 Gly2 2 1 0 Gly3 Gly4 3 4 5 Gly3 Gly5 1 3 2 Gly2 Gly1 3 6 2 Gly4 Gly3 2 2 1 Gly6 Gly4 4 2 1what I expected is: Gly1 Gly2 2 1 0 Gly2 Gly1 3 6 2 Gly3 Gly4 3 4 5 Gly4 Gly3 2 2 1 A vs B, or B vs A are the same... (7 Replies)
Discussion started by: nengcheng
7 Replies

LEARN ABOUT DEBIAN

pct-scanner-script

PCT-SCANNER-SCRIPT(1)					      General Commands Manual					     PCT-SCANNER-SCRIPT(1)

NAME

       pct-scanner-script - easy scan and create merged DjVu and PDF documents for archiving

SYNOPSIS

       pct-scanner-script [--help]

DESCRIPTION

       pct-scanner-script  is  a  bash script and configuration system to easily scan documents and create a digital archiving. It can create DjVu
       PDF and JPEG outputs, in merged and individual files. It also has a configuration system where different  configurations  can  be  defined,
       making it easy to switch between configurations.

       Please use pct-scanner-script --help to find all program options, the complete help, and all examples.

       Features:
	 - auto archiving in merged and individual DjVu, PDF, and JPEG files
	 - auto and manual resume when scanning somehow fails
	 - cascading configuration system, for easy customizing
	 - easy command-line-style bash program, with useful options
	 - archiving made possible with both adf and flatbed scanners
	 - built for productivity and daily use
	 - uses bash, scanadf and other mainstream processing tools
	 - multilanguage commandline output

OPTIONS

       -h, --help, -?
	      Show summary of options, help, and examples.

DEBUGGING

       This  program  is  a  helper  script  to easy scan and automated digital document archiving for normal and adf scanners. You can debug this
       script by running it as bash -x pct-scanner-script [options]. The script is just a nice wrapper for the scanadf, DjVu and PDF tools.

SEE ALSO

       scanadf(1),

AUTHOR

       pct-scanner-script and this manual page are written by:
	      Jelle de Jong <jelledejong@powercraft.nl>.

								  March 31, 2009					     PCT-SCANNER-SCRIPT(1)
All times are GMT -4. The time now is 08:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy