How To Perform Mathematical Operation Within If in awk?

Login or Register to Ask a Question and Join Our Community

How To Perform Mathematical Operation Within If in awk?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How To Perform Mathematical Operation Within If in awk?

09-17-2013

Registered User

76, 0

Join Date: Jul 2007

Last Activity: 2 April 2018, 4:19 PM EDT

Location: India

Posts: 76

Thanks Given: 24

Thanked 0 Times in 0 Posts

How To Perform Mathematical Operation Within If in awk?

Hi All,

I am using an awk script as below:

Code:

awk -F'|' 'BEGIN{OFS="|";} { if ($1==$3 && $3==$7 && $7==$13 && $2==$6 && $6==$11 && $15-$14+1==$11) print $0"|""TRUE"; else print $0"|""FALSE"; }' tempfile.txt

In above script, all conditions are being checked except the one which is underlined. Can any one please help me to identify the error?

Thanks
Angshuman

angshuman

View Public Profile for angshuman

Find all posts by angshuman

09-17-2013

Registered User

3,733, 1,154

Join Date: Apr 2009

Last Activity: 3 August 2016, 11:03 AM EDT

Posts: 3,733

Thanks Given: 7

Thanked 1,154 Times in 1,124 Posts

Try enclosing that part in brackets:

Code:

... && ($15-$14+1==$11)) ...

bartus11

View Public Profile for bartus11

Find all posts by bartus11

09-17-2013

Registered User

23,310, 4,623

Join Date: Aug 2005

Last Activity: 7 July 2020, 11:47 AM EDT

Location: Saskatchewan

Posts: 23,310

Thanks Given: 1,331

Thanked 4,623 Times in 4,217 Posts

The order of operations in that is ambiguous. Parenthesize defensively.

Code:

( ($15-$14)+1==$11 )

Corona688

View Public Profile for Corona688

Visit Corona688's homepage!

Find all posts by Corona688

09-17-2013

Registered User

12,315, 4,560

Join Date: Jul 2012

Last Activity: 22 November 2019, 4:29 PM EST

Location: San Jose, CA, USA

Posts: 12,315

Thanks Given: 952

Thanked 4,560 Times in 3,818 Posts

Quote:

Originally Posted by Corona688

The order of operations in that is ambiguous. Parenthesize defensively.

Code:

( ($15-$14)+1==$11 )

According to the standards, in awk all of the following are required to produce identical results:

Code:

if ($6==$11 && $15-$14+1==$11)
if (($6==$11) && ($15-$14+1==$11))
if (($6==$11) && (($15-$14+1)==$11))
if (($6==$11) && ((($15-$14)+1)==$11))

angshuman,
What was the input line and what field separator were you using when $15-$14+1==$11 did not give you the results you expected; or if you changed the value of $11, $14, or $15 after reading the line, what values did they have when $15-$14+1==$11 gave you unexpected results?

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

09-17-2013

Moderator

3,791, 1,452

Join Date: Oct 2010

Last Activity: 1 August 2020, 1:38 AM EDT

Posts: 3,791

Thanks Given: 183

Thanked 1,452 Times in 1,302 Posts

Quote:

Originally Posted by Corona688

The order of operations in that is ambiguous. Parenthesize defensively.

Code:

( ($15-$14)+1==$11 )

Corona688,

+ and - are associative, so I don't know how there could be any ambiguity.

Chubler_XL

View Public Profile for Chubler_XL

Find all posts by Chubler_XL

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Copy last few lines of a file, perform math operation and iterate further

Hi, I am trying to generate a data of following order: 4 0 1 642 643 4 642 643 1283 1284 4 1283 1284 1924 1925 4 1924 1925 2565 2566 4 2565 2566 3206 3207 4 3206 3207 3847 3848 4 3847 3848 4488 4489 4 4488 4489 5129 5130 ---------------------- 4 1 2 643 644 4 643 644 1284...

2. Shell Programming and Scripting

awk script to find data in three file and perform replace operation

Have three files. Any other approach with regards to file concatenation or splitting, etc is appreciated If column55(billngtype) of file1 contains YMNC or YPBC then pick the value of column13(documentnumber). Now find this documentnumber in column1(Billdoc) of file2 and grep the corresponding...

3. Homework & Coursework Questions

Using dbms_pipe with C++ to perform daabase operation

I am getting two result: string and int in c++ code. That I want to store into database. The request which generates result is very frequent. So each time performing db operation to store the result is costly for me. So how this can be achived using dbms_sql? I dont have any experience and how...

4. Shell Programming and Scripting

Help me to perform count & group by operation in shell scripting?

Hi All, I want to display the distinct values in the file and for each distinct value how may occurance or there. Test data: test1.dat 20121105 20121105 20121105 20121105 20121106 20121106 20121106 20121105 I need to display the output like Output

5. Shell Programming and Scripting

[Solved] Perform an operation to all directories

Sorry, about this thread - I solved my own problem! Thanks for taking a look. edit by bakunin: no problem, but it would have been a nice touch to actually tell us what the solution was. This would have been slightlich more educating than just knowing that you found it. I changed your title to...

6. Shell Programming and Scripting

[Solved] Mathematical operation in multiple files

Hi experts, I need to do a mathematical calculation between each data in 3 different files. Output is using formula (A11+B11)/(1+C11). INPUT : File A.txt A11 A12 A21 A22 File B.txt B11 B12 B21 B22 File C.txt C11 C12 C21 C22 OUTPUT: (A11+B11)/(1+C11) (A12+B12)/(1+C12)...

7. Shell Programming and Scripting

Enter third column & Perform Operation

I am trying to enter a third column in this file, but the third column should that I call "Math" perform a some math calculations based on the value found in column #2. Here is the input file: Here is the desired output: Output GERk0203078$ Levir Math Cotete_1...

8. Shell Programming and Scripting

perform some operation on a specific coulmn starting from a specific line

I have a txt file having rows and coulmns, i want to perform some operation on a specific coulmn starting from a specific line. eg: 50.000000 1 1 1 1000.00000 1000.00000 50000.000 19 19 3.69797533E-07 871.66394 ...

9. Shell Programming and Scripting

How to perform arithmetic operation on date

Hi all, I would appreciate if anyone knows how to perform adding to date. As for normal date, i can easily plus with any number. But when it comes to month end say for example 28 Jun, i need to perform a plus with number 3, it will not return 1 Jul. Thanks in advance for your help.

10. UNIX for Dummies Questions & Answers

Can you perform mathematical equations in UNIX?

Hello one and all, I have a basic background in UNIX, but I was wondering if there is a way to perform simple mathematical equations (like multiplication, addition)? If so, is there a way to multiply values from a column by a value to produce a column with the answers? :confused: I am...

Login or Register to Ask a Question