Sponsored Content
Top Forums Shell Programming and Scripting Deleting values in a column based on conditions Post 302805967 by Sarwagya Jha on Sunday 12th of May 2013 01:02:47 AM
Old 05-12-2013
Deleting values in a column based on conditions

Hi I have a difficulty in writing shell script for performing the tasks.

A B C D
12 230 16 259
18 260 23 283
21 291 36 298
41 309 49 420
52 425 57 450
61 456 70 473
72 475 79 486

If the A(row no.2) < C(row no.1) then delete value A(row no.1) and so on...
For eg..A3< C2 so delete A2 and B2 so the output would be:

12 230 16 259
18 260 23 283
41 309 36 298
52 425 49 420
61 456 57 450
72 475 70 473
79 486

---------- Post updated 05-12-13 at 12:00 AM ---------- Previous update was 05-11-13 at 11:56 PM ----------

Correcting the required output.The below values from the deleted coloms must replace the above values(shift up).

12 230 16 259
18 260 23 283
41 309 36 298
52 425 49 420
61 456 57 450
72 475 70 473
79 486

Thanks. Smilie

---------- Post updated at 12:02 AM ---------- Previous update was at 12:00 AM ----------

Please ignore above output.
Quote:
it looks like this
Code:
12 230  16  259
18 260  23  283
41 309  36  298
52 425  49  420
61 456  57  450
72 475  70  473
        79  486


Last edited by joeyg; 05-14-2013 at 05:33 PM.. Reason: Corrected spelling in title
 

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
mlib_ImageColorYCC2RGB(3MLIB)				    mediaLib Library Functions				     mlib_ImageColorYCC2RGB(3MLIB)

NAME
mlib_ImageColorYCC2RGB - YCC to RGB color conversion SYNOPSIS
cc [ flag... ] file... -lmlib [ library... ] #include <mlib.h> mlib_status mlib_ImageColorYCC2RGB(mlib_image *dst, const mlib_image *src); DESCRIPTION
The mlib_ImageColorYCC2RGB() function performs a color space conversion from ITU-R Rec.601 Y'CbCr to computer R'G'B'. The source and destination images must be three-channel images. It uses the following equation: |R'| |cmat[0] cmat[1] cmat[2]| |Y'| |offset[0]| |G'| = |cmat[3] cmat[4] cmat[5]| * |Cb| + |offset[1]| |B'| |cmat[6] cmat[7] cmat[8]| |Cr| |offset[2]| where cmat[] = { 298.082/256, 0.000/256, 408.583/256, 298.082/256, -100.291/256, -208.120/256, 298.082/256, 516.411/256, 0.000/256 }; offset[] = { -222.922, 135.575, -276.836 }; src[x][y] = { Y', Cb, Cr }; dst[x][y] = { R', G', B' }; PARAMETERS
The function takes the following arguments: dst Pointer to destination image. src Pointer to source image. RETURN VALUES
The function returns MLIB_SUCCESS if successful. Otherwise it returns MLIB_FAILURE. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Interface Stability |Committed | +-----------------------------+-----------------------------+ |MT-Level |MT-Safe | +-----------------------------+-----------------------------+ SEE ALSO
mlib_ImageColorConvert2(3MLIB), mlib_ImageColorConvert2_Fp(3MLIB), mlib_ImageColorRGB2XYZ(3MLIB), mlib_ImageColorRGB2XYZ_Fp(3MLIB), mlib_ImageColorRGB2YCC(3MLIB), mlib_ImageColorRGB2YCC_Fp(3MLIB), mlib_ImageColorYCC2RGB_Fp(3MLIB), attributes(5) SunOS 5.11 2 Mar 2007 mlib_ImageColorYCC2RGB(3MLIB)
All times are GMT -4. The time now is 04:27 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy