Count the decimal numbers with 6 precision


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Count the decimal numbers with 6 precision
# 1  
Old 10-21-2009
Count the decimal numbers with 6 precision

Hi guys,

I have a single column file with millions of records. I want to count the number of records with 6 decimal precision.

for ex:

1234.12
1234.132
12345.12345
1234.1
1234.13
1234.123456
243435.454555


i need to count the number of records with precision of 6 ( i.e here the count is 2)

Any kind of help is appreciated

THanks!
Marcus
# 2  
Old 10-21-2009
Code:
nawk -F. '{if (length($2)==6) s++}END{print s}'  myFile

This User Gave Thanks to vgersh99 For This Post:
# 3  
Old 10-21-2009
Thanks! vgersh99, i will try that out and will let you know about the result.


Thanks!
# 4  
Old 10-21-2009
Code:
grep -c '\.[0-9]\{6\} *$' infile

# 5  
Old 10-21-2009
(g)awk
Code:
awk -F. 'length($2)==6{t++}END{print t}' file

This User Gave Thanks to ghostdog74 For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Decimal numbers and letters in the same collums: round numbers

Hi! I found and then adapt the code for my pipeline... awk -F"," -vOFS="," '{printf "%0.2f %0.f\n",$2,$4}' xxx > yyy I add -F"," -vOFS="," (for input and output as csv file) and I change the columns and the number of decimal... It works but I have also some problems... here my columns ... (7 Replies)
Discussion started by: echo manolis
7 Replies

2. Shell Programming and Scripting

Comparing decimal numbers between 0 and 1

For numbers between 0 and 1 the below logic is not working. Output of above shall be "correct" but its echoing "incorrect".Kindly suggest a=.1 if then echo correct else echo incorrect fi Video tutorial on how to use code tags in The UNIX and Linux Forums. (3 Replies)
Discussion started by: itsvikas
3 Replies

3. UNIX for Dummies Questions & Answers

If then else for decimal numbers part2

Hi, I have a small problem with my script. I have everything in order but it doesnt seem to compare anything less than 1 correctly. If the input is more than 1, then the results is correct. If the input is 0.xxx (anything) it returns erroneous results. Pls help input=0.12 if ; then ... (7 Replies)
Discussion started by: streddy
7 Replies

4. UNIX for Dummies Questions & Answers

Condition for decimal numbers

Hi experts, My number output has somehting like below filename /temp 0.23 10.23 How do i put a condition to the above numbers? e.g if then the . seem to give me problems. Pls help. thanks ---------- Post updated at 05:25 PM ---------- Previous update was at 05:23 PM... (9 Replies)
Discussion started by: streddy
9 Replies

5. Shell Programming and Scripting

Regarding decimal numbers

Hello... I am new to unix and I am wondering if in a C-shell script , Are we supposed to use only whole numbers........ for example..if a program needs to calculate the average of some numbers........ @ avg = (($1 +$2 + $3)/3)) is returning a whole number.........How can a decimal be... (7 Replies)
Discussion started by: ravindra22
7 Replies

6. Shell Programming and Scripting

Comparing Decimal Numbers

Im trying to compare two numbers with decimals but its not working as expected. a=1 b=1.1 if then echo "equal" fi When I do this it says that the numbers are equal. Ultimately Im using -le and -ge in the if statements but I tested with -eq for simplicity. Any way to make this... (3 Replies)
Discussion started by: Grizzly
3 Replies

7. Shell Programming and Scripting

conflict: "for" loops and double precision numbers

Hi folk, Hope you enjoy the summer. I am stock after one day working, the problems are the following: 1) I want to write a for loop in a shell script code that has a double precision step as: #!/bin/bash START=0.00001 STOP=0.001 for((i = START ; i< STOP ; i=2*i)) do echo "$i"... (1 Reply)
Discussion started by: habib
1 Replies

8. Shell Programming and Scripting

decimal numbers

Hi friends How can I use "for loop" for decimal numbers? ex: 0.1 < x < 0.6 I used this commands but does'nt work. LIMIT=0.6 for ((x=0.1; x<=LIMIT; x++)) do - - - done Many thanks (1 Reply)
Discussion started by: snow
1 Replies

9. Shell Programming and Scripting

Devision of Decimal Numbers?

How can i devide decimal numbers? I am getting this kind of error: line 18: 200.2/40.234: syntax error in expression (error token is ".2/40.234") What can i do to work around this problem? Thanks for any advice. (4 Replies)
Discussion started by: Vozx
4 Replies

10. Shell Programming and Scripting

compare decimal numbers

Hi anyone, i need to compare two decimal numbers i thought that it could be do it with if but... :( So, i'm writing in csh and i really apreciate if anyone can help me if ( $ppl_kn <= $ppl_wb ) then echo "############# KNdiscount model has the lowest perplexity" set... (5 Replies)
Discussion started by: tmxps
5 Replies
Login or Register to Ask a Question