Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk replace cells with NaN/delete if condition
Top Forums UNIX for Beginners Questions & Answers awk replace cells with NaN/delete if condition Post 303019109 by RudiC on Saturday 23rd of June 2018 03:27:45 AM
Old 06-23-2018
Quote:
Originally Posted by geomarine
Thanks RudiC, I could just remove the fields with values above -2000, but I want to remain the structure such that I have a 4x4 matrix. then perform calculations only on the remaining values.
I made several attempts to operate only on $3, but couldn't so I decided to try another way, since $1 and $2 can't be affected by the condition (>-2000).

---------- Post updated at 03:35 PM ---------- Previous update was at 03:32 PM ----------

I also considered print $3, so I can apply the condition to it separately, but the whole fields are deleted and could not fit the 4x4 structure I intend to retain.

Help me out - what 4x4- matrix are you talking of? I see a 3 fields file n lines long. If you need to convert that to another matrix, post the rules / logics to be applied and people in here might be able to help.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Comparison of Cells in EXCEL using awk

Hi I have 2 csv files which looks like the following and i have to compare the 2 CSVs and create a third file such that if the value of the 1st cell in A.CSV and the value of the first cell in the B.CSV are same, it should print "SAME" in the third file or else print NOT SAME. Likewise i need... (19 Replies)
Discussion started by: meva
19 Replies

2. Shell Programming and Scripting

Delete line with sed or awk (with specified condition)

Hello. I'm trying to delete the lines of a file does not contain the letter "T " (for example) at position 26. So far, I could only print the result: awk '{if (substr ($ 1,1,26)! ~ / T /) print}' file.txt How I can do to eliminate the lines that meet this condition? Help please. ... (4 Replies)
Discussion started by: </kida>
4 Replies

3. UNIX for Dummies Questions & Answers

How do you delete cells from a space delimited text file given row and column number?

How do you delete cells from a space delimited text file given row and column number? Letś say the row number is r and the column number is c. Thanks! (5 Replies)
Discussion started by: evelibertine
5 Replies

4. UNIX for Dummies Questions & Answers

[Solved] Delete files with condition

I have a directory containing thousands of items “video files”, these items were generated by an application, which generates two items with the same name but with different extensions “.avi and .mp4”. There was a tool in my application to remove one item @ a time. Later I found this tool removes... (5 Replies)
Discussion started by: awadeid
5 Replies

5. Shell Programming and Scripting

Delete records within a file upon a condition

Hi Friends, I have the following file, cat input chr1 1000 2000 chr1 600 699 chr1 701 1000 chr1 600 1710 chr2 900 1800 Now, I would like to see the difference of Record1.Col2 - Record2.Col2 Record1.Col2 - Record2.Col3 Record1.Col3 - Record2.Col2 Record1.Col3 - Record2.Col3 ... (1 Reply)
Discussion started by: jacobs.smith
1 Replies

6. Shell Programming and Scripting

Delete if condition met in a column

i have a table like this: id, senderNumber, blacklist ----------------------------- 1 0835636326 Y 2 0373562343 Y 3 0273646833 Y and I want to delete automatically if a new inserted row on another table consist anything on senderNumber column above using a BASH Script I... (9 Replies)
Discussion started by: jazzyzha
9 Replies

7. UNIX for Dummies Questions & Answers

Replace with condition

I have file input a,b,b,b,ee,b3012dasda,53012,203,1,END,START b,c,b,b,ee,sdasdad,57483,203,,END,START a,b,b,b,ee,b3012dasda,53012,203,,END,START b,c,b,b,ee,sdasdad,57483,203,1,END,START I want every ",," in $9 replace with ,0, the output should be ... (3 Replies)
Discussion started by: radius
3 Replies

8. Shell Programming and Scripting

Delete File in a Directory Using a Condition

Hello, I have a directory with many files whose creation time is distributed all over the day. I need ANY 20 files per hour. So, I need 20 files for hour 00 20 files for hour 01 ... 20 files for hour 23 What I have done so far is not great. Here is the code: # get the Month a=`echo... (8 Replies)
Discussion started by: shekhar2010us
8 Replies

9. Shell Programming and Scripting

Delete complete row according to condition

Gents, Please can you help me. In the range 4-24 column the values are duplicate some times and I will like to delete the fist occurrence and keep the last only. The file is not sorted and I can sorted because from column 75 to the end the file is increase by time.. I have a file like this... (10 Replies)
Discussion started by: jiam912
10 Replies

10. Shell Programming and Scripting

awk to replace a specific field in certain condition

Hi, I have a file like below PRUM,67016800 ,CC ,C1,67016800 , ,Y,Y,2 ,CK,BX,FOX ,00000001,EA,00000001,20141120 00:00:00, ,N,Y,Y,CK ABCDEF... (7 Replies)
Discussion started by: mady135
7 Replies

LEARN ABOUT MOJAVE

ctanh

CTANH(3)						   BSD Library Functions Manual 						  CTANH(3)

NAME

     ctanh -- complex hyperbolic tangent function

SYNOPSIS

     double complex
     ctanh(double complex z);

     long double complex
     ctanhl(long double complex z);

     float complex
     ctanhf(float complex z);

DESCRIPTION

     ctanh(z) computes the hyperbolic tangent of the complex floating-point number z.

     For all complex floating point numbers z,

	   ctanh(conj(z)) = conj(ctanh(z)),
	   ctanh(-z) = -ctanh(z).

SPECIAL VALUES

     The symmetries of ctanh() are used to abbreviate the specification of special values.

     ctanh(0 + 0i) returns 0 + 0i.

     ctanh(0 + inf i) returns NaN + NaN i, and raises the invalid flag.

     ctanh(0 + NaN i) returns NaN + NaN i.

     ctanh(x + inf i) returns NaN + NaN i, and raises the invalid flag, for finite nonzero x.

     ctanh(x + NaN i) returns NaN + NaN i, for finite nonzero x.

     ctanh(inf + 0i) returns 1 + 0i.

     ctanh(inf + yi) returns 1 +- 0i, for finite positive y, with the sign chosen to match the sign of sin(2y).

     ctanh(inf + inf i) returns 1 + 0i.

     ctanh(inf + NaN i) returns 1 + 0i.

     ctanh(NaN + 0i) returns NaN + 0i.

     ctanh(NaN + yi) returns NaN + NaN i, for nonzero numbers y.

     ctanh(NaN + NaN i) returns NaN + NaN i.

NOTES

SEE ALSO

     ctan(3) complex(3)

STANDARDS

     The ctanh() function conforms to ISO/IEC 9899:2011.

4th Berkeley Distribution					 December 11, 2006					 4th Berkeley Distribution
All times are GMT -4. The time now is 11:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy