Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

how to do arithmetic operations in one line command

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting how to do arithmetic operations in one line command
# 1  
Old 07-01-2011
how to do arithmetic operations in one line command
I have a file like this

Code:
product   qty1   qty2	value
cola        50	25	1
pepsi      100     75	2
muffin     25	30	0.5

would like to do the following operations with one line command


1) disply the line having "Qty1" greater than or equal to 50
2) display the line Qty1 - Qty2 greater than 20

Need a simple one line command to do these mathematical operations and take decision

thank you in advance
Last edited by joeyg; 07-01-2011 at 04:37 PM.. Reason: Please wrap scripts and data with CodeTags
# 2  
Old 07-01-2011
Code:
awk '(NR>1) && (($2>=50) || ( ($3-$2)>20))' datafile

The (NR>1) && is just to prevent it from printing that first line with all the titles, if your data doesn't really have that lop it off.
This User Gave Thanks to Corona688 For This Post:
johnveslin
# 3  
Old 07-01-2011
Code:
awk '$2>=50||$2-$3>20' file

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell arithmetic : operations on decimal points

i am having a varialbe a , which is input to my file i want to multiply this input with value .43, and assign it to variable b. i tried it as below: #!/bin/sh a=$1 b=`expr $1\*0.43` echo b=$b error : expr: non-integer argument Please tell me , how to do this. Thanks (10 Replies)
Discussion started by: rishifrnds
10 Replies

2. Shell Programming and Scripting

Performing arithmetic operations on output of `wc -l`

Hi I want to perform arithmetic operations on output of `wc -l`. for example user046@sshell ~ $ ls -l total 0 where "total 0" will increase one line in wc -l filecount=`ls -l | wc -l` here $filecount will be 1 but is should be 0 how to get rid of it ? (1 Reply)
Discussion started by: anandgodse
1 Replies

3. UNIX for Dummies Questions & Answers

Multiple arithmetic operations in a single line

hi, I want to do multiple arithmetic operations in a single line. I tried with the following line total_size=`expr ($total_size + $file_size) / 1024` this line is throwing me error. Im working on korn shell. Can i know how to do multiple arithmetic operations in a single line (2 Replies)
Discussion started by: midhun19
2 Replies

4. UNIX for Dummies Questions & Answers

arithmetic operations on 1 column of a file

Hi, I have a file with thousands of lines like this: Chr1 477515 . ACCCC ACCC 17.7 . INDEL;DP=17;AF1=1;CI95=0.5,1;DP4=0,1,0,3;MQ=32;PV4=1,0.036,1,1 Chr1 481987 . A AAAT 62 . INDEL;DP=11;AF1=1;CI95=0.5,1;DP4=0,0,1,3;MQ=41 I want to make a file with... (2 Replies)
Discussion started by: fadista
2 Replies

5. Shell Programming and Scripting

awk command: column operations

I have a txt file with two columns Freq Loss 10 30 20 40 30 10 40 50 50 60i have used the below code to get the minimum value out of this array in second cloumn. awk 'NR==N{min=$N;max=$N}NR>N{if ($N>max){max=$N};if ($N<min){min=$N}}END {print... (3 Replies)
Discussion started by: shashi792
3 Replies

6. Shell Programming and Scripting

Arithmetic operations in bash,ksh,sh

Guys, The below expression is valid in which shells (sh,ksh,bash,csh)? VAR1=2 VAR2=$(($VAR1 -2)) Thanks (1 Reply)
Discussion started by: rprajendran
1 Replies

7. Shell Programming and Scripting

Need help is manipulating a file with some arithmetic operations using bash script

Friends, I have a file with contents like: interface Serial0/4/0/0/1/1/1/1:0 encapsulation mfr multilink group 101 Now I need to manipulate the file in such a way that to all the numbers less than 163, 63 gets added and to all numbers greater than 163, 63 gets deducted.(The numbers... (2 Replies)
Discussion started by: shrijith1
2 Replies

8. Shell Programming and Scripting

command for a series of operations

I want to append a file containing a list of names and the sorted contents of the file should be copied to a new file. All this should be on a single line( using pipes and redirection) Pls help .. thankyou (1 Reply)
Discussion started by: phiber_optik
1 Replies

9. Shell Programming and Scripting

problem in arithmetic operations

hello all, i am having a variable with a value of 0000010000 and if i add the variable with some no: suppose i=0000010000 n=`expr $i + 1` echo $n the output i am reciving is 10001 .it deletes all the zeros but i need result as 0000010001.. please help me... thanks in... (3 Replies)
Discussion started by: ithirak17
3 Replies
Login or Register to Ask a Question