awk sort based on difference of fields and print all fields Post: 302952805

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl function to sort a file based on key fields

Hi, I am new to PERL.I want to sort all the lines in a file based on 1,2 and 4th filelds. Can U suggest me a command/function in perl for this operation..

2. Shell Programming and Scripting

awk sed cut? to rearrange random number of fields into 3 fields

I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want. The vendor wants me to submit three fields to them. Field 1 is the studentid field,...

3. Shell Programming and Scripting

awk /nawk :: print the everything except the first and the last fields

format of file1 "file1.txt" 1 2 3 4 A B C XX YY ZZ AA WWW The output must contain except the first and last column the output must be 2 3 B YY ZZ AA

4. Shell Programming and Scripting

awk - print all fields except for last field

How do I print all the fields of a record except for the $(NF) field?

5. Shell Programming and Scripting

awk to print range of fields

Hi file.in and file.out are in csv format. the code I have now is, cat file.in | awk -F"," '!($1$2$3$4$5$6$7$8 in a){a;print $0}' > file.out Here, I am printing entire line using $0. however, I want to print $1 to $150 and it should be in csv format. Cut -d is not good in performace....

6. Shell Programming and Scripting

How to print 1st field and last 2 fields together and the rest of the fields after it using awk?

Hi experts, I need to print the first field first then last two fields should come next and then i need to print rest of the fields. Input : a1,abc,jsd,fhf,fkk,b1,b2 a2,acb,dfg,ghj,b3,c4 a3,djf,wdjg,fkg,dff,ggk,d4,d5 Expected output: a1,b1,b2,abc,jsd,fhf,fkk...

7. Shell Programming and Scripting

awk - compare 1st 15 fields of record with 20 fields

I'm trying to compare 2 files for differences in a selct number of fields. When differnces are found it will write the whole record of the second file including appending '|C' out to a delta file. Each record will have 20 fields, but only want to do comparison of 1st 15 fields. The 1st field of...

8. Shell Programming and Scripting

awk print even fields of file

Hello: I want to print out the even number of fields plus the first column as row identifiers. input.txt ID X1 ID X2 ID X3 ID X4 A 700 A 1200 A 400 A 1300 B 2000 B 1000 B 2000 B 600 C 1400 C 200 C 1000 C 1200 D 1300 D 500 D 600 D 200and the output is: output.txt ID X1 X2 X3...

9. Shell Programming and Scripting

Print . in blank fields to prevent fields from shifting

The below code works great, kindly provided by @Don Cragun, the lines in bold print the current output. Since some of the fields printed can be blank some of the fields are shifted. I can not seem too add . to the blank fields like in the desired output. Basically, if there is nothing in the field...

10. Shell Programming and Scripting

awk to print lines based on text in field and value in two additional fields

In the awk below I am trying to print the entire line, along with the header row, if $2 is SNV or MNV or INDEL. If that condition is met or is true, and $3 is less than or equal to 0.05, then in $7 the sub pattern :GMAF= is found and the value after the = sign is checked. If that value is less than...

LEARN ABOUT DEBIAN

maphimbu

MAPHIMBU(1)							   User Commands						       MAPHIMBU(1)

NAME

       maphimbu -  histogram builder for 1-d numerical and text data

SYNOPSIS

       maphimbu [OPTION]... [FILE]

DESCRIPTION

       This  program produces 1-d histograms from numerical or text data input. It can be also used to estimate the probability distribution func-
       tion of a numerical variable - see http://en.wikipedia.org/wiki/Probability_density_function.

OPTIONS

       -x <int>
	      x-data column (default is 1)

       -y <int>
	      y-data column (default is 2); It is considered only when combined with '-m' or '-S'

       -d <float|int>
	      delta size (dx-resolution) in case of numerical data; Keep in mind that 2 is not the same as 2.0: in the first case the numbers  are
	      treated as integers, in the latter as floats.

       -n     normalize  the  result  A)  non-numerical data: n(x) = counts(x)/sum_of_counts B) numerical data: the normalized probability density
	      func.

	      is P(-INF < x <INF) = Int_[-INF:INF] P(x)*dx = 1 ; For the numerical integration an open x-data interval is assumed.

       -N     normalize data against the total sum of counts (same as option '-n' with case A forced)

       -U     normalize the result with x-range mapped to unit; The x-values are mapped to the interval [0:1], respectively Int_[0:1] P(x)*dx = 1;
	      This option is mutually exclusive with '-n'.

       -S     compute sums and normalized sums of y-values; The total sum of all y-values is used for the normalization.

       -m     compute the arithmetic mean of y-values in the respective x-bar

       -s <int>
	      sort output using the specified column; Header is skipped in this case.

       -g <int>
	      sort output numerically using the specified column; Header is skipped in this case.

       -r     do reverse sorting (in combination with '-g' and '-s')

       -C     center histogram bars (shifts x-axis by 0.5*dx)

       -X     treat hole line as one string (single data record)

       -H     print a data description header

       -V     print program version and exit

       --version
	      output version and copyright information

       --help display help

       -h     display short help (options summary)

       Note: this program is not intended for use in high order numerical computations.

REPORTING BUGS

       Report bugs to <gnu@mirendom.net>

COPYRIGHT

       Copyright (C) 2003-2007, 2009, 2011 Dimitar Ivanov

       License: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
       This is free software: you are free to change and redistribute it.  There is NO WARRANTY, to the extent permitted by law.

maphimbu 2.8.4							   February 2012						       MAPHIMBU(1)