Decimal places


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Decimal places
# 8  
Old 04-25-2011
Code:
kamaraj@kamaraj-laptop:~/Desktop/Scripts$ awk '{printf("%.2f\n",$1)}' decimal_file 
134.40
126.70
144.00
555.00
77.88

kamaraj@kamaraj-laptop:~/Desktop/Scripts$ cat decimal_file 
134.4
126.7
144
555
77.88

# 9  
Old 04-25-2011
Quote:
Originally Posted by arunmanas
Excel file look like:

134.4
126.7
144
555
77.88

the required output is

134.40
126.70
144.00
555.00
77.88
Code:
# while read -r l ; do echo "scale=2 ; $l*1/1"|bc ; done<infile
134.40
126.70
144.00
555.00
77.88

# 10  
Old 04-25-2011
HI Kamaraj,,,

thanks a lot..

code wrks fine

---------- Post updated at 03:46 AM ---------- Previous update was at 03:43 AM ----------

HI kamraj,,

do u knw how to include thousand places for these numbers

input:

12223
45679.55
3344

output:
12,223
45,679.55
3,344
# 11  
Old 04-25-2011
Try this sed command:
Code:
$
$ echo 123456.00  | sed -e :a -e 's/^\([^.]*[0-9]\)\([0-9]\{3\}\)/\1,\2/;ta'
123,456.00
$ echo 123456 | sed -e :a -e 's/^\([^.]*[0-9]\)\([0-9]\{3\}\)/\1,\2/;ta'
123,456
$ echo 123456789987654321123456789.12345 |  sed -e :a -e 's/^\([^.]*[0-9]\)\([0-9]\{3\}\)/\1,\2/;ta'
123,456,789,987,654,321,123,456,789.12345
$ echo -123456.66 |  sed -e :a -e 's/^\([^.]*[0-9]\)\([0-9]\{3\}\)/\1,\2/;ta'
-123,456.66
$

# 12  
Old 04-25-2011
Code:
#!/bin/ksh93

while read num
do
   printf "%.2,f\n" $num
done < infile

infile:
Code:
134.4
126.7
144
555
77.88
12223
45679.55
3344

output:
Code:
134.40
126.70
144.00
555.00
77.88
12,223.00
45,679.55
3,344.00

BTW, this does not works for lakhs
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Calculate the constant e to 14+ decimal places using integer maths.

Hi guys... I am loving this integer maths thing. 64 bit systems are certainly easier than 32 bit, but hey, I don't intend to leave out my fav' platform. Using one of the 'Brothers' methods, URL inside the code. #!/bin/sh # # #!/usr/local/bin/dash # e_constant.sh # Brother's formula . #... (2 Replies)
Discussion started by: wisecracker
2 Replies

2. Shell Programming and Scripting

Sum the fields with 6 decimal places - getting only 2 decimal places as output

I used the below script to Sum up a field in a file based on some unique values. But the problem is when it is summing up the units, it is truncating to 2 decimals and not 6 decimals as in the input file (Input file has the units with up to 6 Decimals – Sample data below, when the units in the 2... (4 Replies)
Discussion started by: brlsubbu
4 Replies

3. Shell Programming and Scripting

Printing with decimal places from last 4 digits

I have input file like below, 201424|9999|OSS|622010|RGT|00378228764 201424|8888|OM|587079|RGT|00284329675 201424|7777|OM|587076|RGT|00128671024 201424|6666|OM|581528|RGT|00113552084 Output should be like below, should add decimal (.) from last 4 digits. ... (2 Replies)
Discussion started by: vinothsekark
2 Replies

4. Shell Programming and Scripting

How to round up value upto 2 decimal places using sed?

Please help me in rounding up value upto 2 decimal palces using sed command #!/usr/bin/bash a=15.42 b=13.33 c=`echo $a*$b |bc -l` echo $c above code is is giving output "205.5486" but i want the output as "205.55" Thank you... (15 Replies)
Discussion started by: ranabhavish
15 Replies

5. Shell Programming and Scripting

Bash Rounding to 2 decimal places

I have a number in a bash variable n, and want to round it to 2 decimal places. How can I do that? n=0.0867268 Need to have num=0.09 (1 Reply)
Discussion started by: kristinu
1 Replies

6. Shell Programming and Scripting

Arithmetic but keep 2 decimal places

I am trying to perform arithmetric, for example, to increment the value of variable $a (say 3) by 0.05 but when I tried the following expression let a=a+0.05 or a=$((a+0.05)) both returned 3.0499999999999998 I want to keep 2 decimal places so it returns 3.05 instead. (6 Replies)
Discussion started by: piynik
6 Replies

7. Shell Programming and Scripting

Four decimal places with awk

i have a script in which awk prints "($2-1700)/10000" and the answer is -0.07,but i want the answer in 4 decimal places. that is -0.0700. How can i sue awk to get my results in four decimal places (4 Replies)
Discussion started by: tomjones
4 Replies

8. Shell Programming and Scripting

Using the "Less Than" (-lt) switch on numbers with decimal places?

I'm using shell scripts to run some commands for the Configuration Management tool called Telelogic Synergy. I need to get the script to compare version numbers of files. The version numbers of the files are part of the actual filename, such as the following example: example_file-1... (7 Replies)
Discussion started by: Glyn_Mo
7 Replies

9. Shell Programming and Scripting

trimm up the decimal places in output

I have a perl script that reports the avg time of a application call and the total number of calls. This works fine, however I would like to trim the number of decimal places reported from 12 to like 3 and I don't know how. Any suggestions? Here is what I use to get the avg time... for $eRef (... (2 Replies)
Discussion started by: theninja
2 Replies
Login or Register to Ask a Question