Sponsored Content
Top Forums Shell Programming and Scripting awk sort based on difference of fields and print all fields Post 302952884 by RudiC on Monday 24th of August 2015 04:36:20 AM
Old 08-24-2015
Please use code tags as required by forum rules.

Try an adaption of vgersh99's proposal (and adapt to taste), applied on a fictious input file prepared from your above "sample":
Code:
awk '$0=sprintf("%14.12f", $5-$7) OFS $0' file1 | sort -k1,1n
-0.000000000081 DC: XY_CLK__Q__F_E__MODE2 G:-2L quad:slmx 3.900000e-11 -> 1.200000e-10
-0.000000000081 DC: XY_CLK__Q__F_E__MODE2 G:-2 quad:slmx 3.900000e-11 -> 1.200000e-10
-0.000000000081 DC: XY_CLK__Q__F_E__MODE3 G:-2L quad:slmx 3.900000e-11 -> 1.200000e-10
-0.000000000081 DC: XY_CLK__Q__F_E__MODE3 G:-2 quad:slmx 3.900000e-11 -> 1.200000e-10
-0.000000000076 DC: XY_CLK__Q__F_E__MODE4 G:-1 quad:slmn 1.700000e-11 -> 9.300000e-11
-0.000000000009 DC: XY_CE__Q G:-2LV quad:slmn 1.850000e-10 -> 1.940000e-10
-0.000000000009 DC: XY_CE__Q__MODE4 G:-2L quad:slmn 1.200000e-10 -> 1.290000e-10
-0.000000000009 DC: XY_CE__Q__MODE4 G:-2 quad:slmn 1.200000e-10 -> 1.290000e-10
-0.000000000009 DC: XY_CLK__CE__HOLD_FALLING G:-2LV quad:ftmn -1.600000e-11 -> -7.000000e-12
-0.000000000008 DC: XY_CE__Q__MODE1 G:-2LV quad:ftmn 9.200000e-11 -> 1.000000e-10
-0.000000000008 DC: XY_CE__Q__MODE1 G:-3 quad:slmn 1.130000e-10 -> 1.210000e-10
-0.000000000008 DC: XY_CE__Q__MODE2 G:-2LV quad:ftmn 9.200000e-11 -> 1.000000e-10

Had you supplied a sample input file in the first place, an immediate taylored solution would have been possible .
 

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.. (5 Replies)
Discussion started by: karthikd214
5 Replies

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,... (4 Replies)
Discussion started by: axo959
4 Replies

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 (8 Replies)
Discussion started by: centurion_13
8 Replies

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? (4 Replies)
Discussion started by: locoroco
4 Replies

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.... (3 Replies)
Discussion started by: krishnix
3 Replies

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... (6 Replies)
Discussion started by: 100bees
6 Replies

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... (7 Replies)
Discussion started by: sljnk
7 Replies

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... (3 Replies)
Discussion started by: yifangt
3 Replies

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 Replies)
Discussion started by: cmccabe
10 Replies

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... (0 Replies)
Discussion started by: cmccabe
0 Replies
bamg(1rheolef)							    rheolef-6.1 						    bamg(1rheolef)

NAME
bamg - bidimensional anisotropic mesh generator SYNOPSIS
bamg options -g input[.bamgcad] -o ouput[.bamg] EXAMPLE
bamg -g toto.bamgcad -o toto.bamg OUTLINE OF THE COMMANDS
This software can create a mesh from a geometry adapt a mesh from a background mesh using a metric or solution file do smoothing to make quadrilaterals and to split internal edge with 2 boundary vertices in an existing mesh (in this case the metric is use to change the definition of the element's quality). construct just a metric file, if you have an other mesher do the P1 interpolation of the solution on another mesh: CREATE A MESH FROM A GEOMETRY
input file with -g filename (file type DB mesh). output file arguments -oxxxx filename where xxxx is the type of output file (see below for more details). smoothing, quad, utility and other parameters. In addition, metric specication may be prescribed with the help of -M filename argument (file type Metric). All the options are described below. ADAPT A MESH FROM A BACKGROUND MESH USING A METRIC OR SOLUTION FILE
input files -b filename where the suffixe of the file define the type of the file `.amdba', `.am_fmt', `.am', `.ftq', `.nopo' and other- wise the file is a BD mesh file. input `-M filename' (file type Metric) or -MBB filename or -Mbb filename (solution file type BB or bb). metric control parameters, -err val, -errg val,.... output file arguments reqired interpolation, smoothing, quad, utility parameter, and other parameter do smoothing, to make quadrilaterals: and to split internal edge with 2 boundary vertices in an existing mesh (in this case the metric is use to change the definition of the element's quality). input files -r filename(file type DB mesh). -M filename (file type Metric). output file -o filename (file type DB mesh). some other parameter: @table @code -thetaquad val: to create quad with 2 triangles -2: to create the submesh with mesh size h = h/2 -2q: to split all triangles in 3 quad. and to split all quad. in 4 quad. -NbSmooth ival: to change the number of smoothing iteration (3 by default if the metric eld is set with arguments : -M or -Mbb, 0 otherwise. ... @end table construct just a metric file, if you have an other mesher: input files -r filename (file type DB mesh). --Mbb filename or -MBB filename + all the arguments of the metric construction output file -oM filename (file type Metric). do the P1 interpolation of the solution on another mesh: input files -r filename (file type DB mesh). --rBB filename or -rbb filename output file -wBB filename or -wbb filename METRIC COMPUTATIOB OPTIONS
These options are relevant when computing a metric from a scalar field provided in a .bb file. Notice that, when providing a tensor metric in the .bb file, the metric computation is not performed and these options are not relevent. -RelError compute the metric with a relative error. This is the default. -CutOff float the cut-off value used for the relative error criteria. Default value is 1e-5. -AbsError compute the metric with a relative error rheolef-6.1 rheolef-6.1 bamg(1rheolef)
All times are GMT -4. The time now is 03:46 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy