Sponsored Content
Top Forums Shell Programming and Scripting Deleting values in a column based on conditions Post 302807109 by Sarwagya Jha on Tuesday 14th of May 2013 07:01:03 AM
Old 05-14-2013
Thanks for the suggestions. Re-framing my question.

I have a difficulty in writing shell script for performing the tasks.
I have a file group.dat containing below values.
Quote:
12 230 16 259
18 260 23 283
21 263 36 298
41 309 49 420
52 425 57 450
53 431 70 473
72 475 79 486
Let suppose 1st colum be A,2nd be B,3rd be C and 4th colom be D.
Now need to compare the 2nd row of A with 1st row of C
condition is
Quote:
(A2<C1)
,ie,
Quote:
18<16
, then delete A1 and B1 and shift the values upwards and the loop continues.
We can see that in file group.dat
Quote:
A3(21) <C2( 23)
also
Quote:
A6(53) <C5( 57)
.

So the output I want is
Code:
12 230 16 259
21 263 23 283
41 309 36 298
53 431 49 420
72 475 57 450
       70 473
       79 486

Please let me know if I made my requirement clear. Smilie
Thanks in advance.

Last edited by Sarwagya Jha; 05-14-2013 at 09:20 AM..
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to pick values from column based on key values by usin AWK

Dear Guyz:) I have 2 different input files like this. I would like to pick the values or letters from the inputfile2 based on inputfile1 keys (A,F,N,X,Z). I have done similar task by using awk but in that case the inputfiles are similar like in inputfile2 (all keys in 1st column and values in... (16 Replies)
Discussion started by: repinementer
16 Replies

2. Shell Programming and Scripting

How to averaging column based on first column values

Hello I have file that consist of 2 columns of millions of entries timestamp and throughput I want to find the average (throughput ) for each equal timestamp before change it to proper format e.g : i want to average 2 coloumnd fot all 1308154800 values in column 1 and then print... (4 Replies)
Discussion started by: aadel
4 Replies

3. Shell Programming and Scripting

Deleting a row based on fetched value of column

Hi, I have a file which consists of two columns but the first one can be varying in length like 123456789 0abcd 123456789 0abcd 4015 0 0abcd 5000 0abcd I want to go through the file reading each line, count the number of characters in the first column and delete... (2 Replies)
Discussion started by: swasid
2 Replies

4. Shell Programming and Scripting

Deleting row if all column values are a particular string

Hello, I have a very large file for which I would like to remove all rows for which the value of columns 2-5 is zero. For instance I would like this file: contig1, 0, 0, 0, 0 contig2, 1, 3, 5, 0 contig3, 0, 0, 0, 0 contig4, 0, 5, 6, 7 To become this file: contig2, 1, 3, 5,0 ... (17 Replies)
Discussion started by: mouchkam
17 Replies

5. Shell Programming and Scripting

Adding values of a column based on another column

Hello, I have a data such as this: ENSGALG00000000189 329 G A 4 2 0 ENSGALG00000000189 518 T C 5 1 0 ENSGALG00000000189 1104 G A 5 1 0 ENSGALG00000000187 3687 G T 5 1 0 ENSGALG00000000187 4533 A T 4 2 0 ENSGALG00000000233 5811 T C 4 2 0 ENSGALG00000000233 5998 C A 5 1 0 I want to... (3 Replies)
Discussion started by: Homa
3 Replies

6. Shell Programming and Scripting

Remove the values from a certain column without deleting the Column name in a .CSV file

(14 Replies)
Discussion started by: dhruuv369
14 Replies

7. Shell Programming and Scripting

Create new file with increment column based on conditions

Hello, Using bash script, i need to process the following file: 887,86,,2013-11-06,1,10030,5,2,0,200,, 887,86,,2013-11-05,1,10030,5,2,0,199,, 887,138,,2013-11-06,1,10031,6,2,0,1610612736,, 887,164,,2013-11-06,1,10000,0,2,0,36000,, and to create a new file such as the below ... (2 Replies)
Discussion started by: JonhyDeep
2 Replies

8. Shell Programming and Scripting

Sum column values based in common identifier in 1st column.

Hi, I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column) The input is for example, after sorted: K00001 1 1 4 3... (8 Replies)
Discussion started by: sargotrons
8 Replies

9. Shell Programming and Scripting

Concatenate values in the first column based on the second column.

I have a file (myfile.txt) with contents like this: 1.txt apple is 3.txt apple is 5.txt apple is 2.txt apple is a 7.txt apple is a 8.txt apple is a fruit 4.txt orange not a fruit 6.txt zero isThe above file is already sorted using this command: sort -k2 myfile.txtMy objective is to get... (3 Replies)
Discussion started by: shoaibjameel123
3 Replies
TERM(7) 						 Miscellaneous Information Manual						   TERM(7)

NAME
terminals- conventional names DESCRIPTION
These names are used by certain commands and are maintained as part of the shell environment (see sh(1),environ(5)). 1620 DIABLO 1620 (and others using HyType II) 1620-12 same, in 12-pitch mode 300 DASI/DTC/GSI 300 (and others using HyType I) 300-12 same, in 12-pitch mode 300s DASI/DTC 300/S 300s-12 same, in 12-pitch mode 33 TELETYPE(R) Model 33 37 TELETYPE Model 37 40-2 TELETYPE Model 40/2 43 TELETYPE Model 43 450 DASI 450 (same as Diablo 1620) 450-12 same, in 12-pitch mode 450-12-8 same, in 12-pitch, 8 lines/inch mode 735 Texas Instruments TI735 (and TI725) 745 Texas Instruments TI745 dumb terminals with no special features hp Hewlett-Packard HP264? series terminals 4014 Tektronix 4014 tn1200 General Electric TermiNet 1200 tn300 General Electric TermiNet 300 vt05 Digital Equipment Corp. VT05 Commands whose behavior may depend on the terminal accept arguments of the form -Tterm, where term is one of the names given above. If no such argument is present, a command may consult the shell environment for the terminal type. SEE ALSO
stty(1), tabs(1), plot(1), sh(1), environ(5) troff(1) for nroff BUGS
The programs that ought to adhere to this nomenclature do so only fitfully. TERM(7)
All times are GMT -4. The time now is 01:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy