Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

awk Division and modulus

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk Division and modulus
# 1  
Old 12-16-2009
awk Division and modulus
I need to read the file divide 3 column with 2nd and run a modulus of 10 and check whether the remainder is zero or not if not print the entire line.

Code:
cat filename | awk '{ if ($3 / $2 % 10 != 0) print $0}'

Whats wrong with it ?
# 2  
Old 12-16-2009
You are probably just missing brackets around the ($3 / $2) part.

You can do this more simply, though:

Code:
awk '($3 / $2) % 10' filename

# 3  
Old 12-16-2009
Ok its sorted now

Code:
cat $FILE | awk '{if ($3/$2 % 10 != 0)  {print} }' | awk '{print $1 , $4 , $5}'

But the values in column 4 , 5, 6 , 7, 8 are are seperated by spaces and awk treates them as different values

Example
ABC OP OPPO NOP

The problem is the no is not consistent so it might contain some more character with more spaces like

ABC OP OPPO NOP OP JHIJ

I need them to be treated as I column
# 4  
Old 12-16-2009
The use of cat is redundant, it's sufficient to use one awk command to get your output IMHO.

Post your input file and the desired output.
# 5  
Old 12-16-2009
input File
Code:
COL1                         COL2                         COL3                         COL4
USGDQ0910MJT       46.00000000           49.000000000000000 PUT  ABC JAN 10   46.0  ABC SCIENCES INC          
COL5
PUT  OP JAN 10   49.0     ABC SCIENCES INC

Need COL1, COL2, COL3, COL4,COL5

---------- Post updated at 05:44 PM ---------- Previous update was at 04:37 PM ----------

Code:
cat FILE| awk '{if ($3/$5 % 10 != 0)  {print $0} }' | awk 'BEGIN { OFS="," } -F" " {print $1,$2,$3,$4,$5}'

But all records are shown on same line , how does records on new line
Last edited by Franklin52; 12-16-2009 at 09:03 AM.. Reason: Please use code tags!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk - continue when encountered division error

Hello, How can I add a logic to awk to tell it to print 0 when encountering a division by zero attempted? Below is the code. Everything in the code works fine except the piece that I want to calculate read/write IO size. I take the kbr / rs and kbw / ws. There are times when the iostat data... (5 Replies)
Discussion started by: tommyd
5 Replies

2. Shell Programming and Scripting

awk Division By Zero Bypass

Hi Friends, I don't understand why "a" is always being printed as zero, when I execute the following command. awk '{if($6||$8||$10||$12==0)a=b=c=d=0;else (a=$5/$6);(b=$7/$8);(c=$9/$10);(d=$11/$12); {print... (6 Replies)
Discussion started by: jacobs.smith
6 Replies

3. Shell Programming and Scripting

awk - Division with condition

Hi Friends, I have an input file like this cat input chr1 100 200 1 2 chr1 120 130 na 1 chr1 140 160 1 na chr1 170 180 na na chr1 190 220 0 0 chr1 220 230 nd 1 chr2 330 400 1 nd chr2 410 450 nd nd chr3 500 700 1 1 I want to calculate the division of 4th and 5th columns. But, if... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

4. Shell Programming and Scripting

variables division with awk

hello i try to divide 2 variables in order to get a percentage--that's why i'm not interested in integer division--but nothing seems to work I think awk is suitable for this but i'm not quite sure how to use it.. any ideas? here's what I want to do: percentage = varA/varB thank you (2 Replies)
Discussion started by: vlm
2 Replies

5. Shell Programming and Scripting

awk & division

vmstat|awk '{print $3}'|tail -1 returns 6250511, but what I need is 24416, which is 6250511 divided by 256. Please advise. Thank you so much (2 Replies)
Discussion started by: Daniel Gate
2 Replies

6. Shell Programming and Scripting

Division problem -Awk

input one two three four 0 0 0 10424 0 102 0 15091 1 298 34 11111 0 10 0 1287 scripts awk 'NR>1{print ($1/$2) / ($3/$4)}' awk 'NR>1{ if ($1 ||$3 ||$2|| $4 == 0) print 0; else print (($1/$2)/($3/$4))}' error awk: division by zero input record number 1, file rm source line... (9 Replies)
Discussion started by: quincyjones
9 Replies

7. Shell Programming and Scripting

awk division error - 0

input 0 0 9820373 2069 0 0 11485482 awk '{print ($1/$3) / ($4/$7)}' input error Is there any way to fix this problem ? (25 Replies)
Discussion started by: quincyjones
25 Replies

8. UNIX for Advanced & Expert Users

awk: division by zero

I received error "awk: division by zero" while executing the following statement. SunOS 5.10 Generic_142900-15 sun4us sparc FJSV,GPUZC-M echo 8 | awk 'END {printf ("%d\n",NR/$1 + 0.5);}' file1.lst awk: division by zero Can someone provide solution? Thanks Please use code... (11 Replies)
Discussion started by: kumar77
11 Replies

9. Shell Programming and Scripting

awk error message: division by zero attempted

Hi, I'm executing unixbench tool v4.1 on an embedded system and I'm getting these error messages: Execl Throughput 1 2 3awk: /unixbench/unixbench-4.1.0/pgms/loops.awk:38: (FILENAME=- FNR=4) fatal: division by zero attempted Pipe Throughput 1 2 3 4 5 6 7 8 9 10awk:... (3 Replies)
Discussion started by: rogelio
3 Replies

10. Shell Programming and Scripting

Division by zero error message in AWK

How can I modify my awk code to get rid of the divion by zero error message? If I run the script without an input file, it should return error message "Input file missing" but not divison by zero. Code: #!/bin/nawk -f BEGIN { if (NR == 0) {print "Input file... (4 Replies)
Discussion started by: Pauline mugisha
4 Replies
Login or Register to Ask a Question