Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sum the fields with 6 decimal places - getting only 2 decimal places as output
Top Forums Shell Programming and Scripting Sum the fields with 6 decimal places - getting only 2 decimal places as output Post 303013458 by brlsubbu on Wednesday 21st of February 2018 02:47:28 PM
Old 02-21-2018
Sum the fields with 6 decimal places - numbers with all zeroes after the decimal is truncated
Thank you for your help. this really works in terms of adding.

But, I have a new problem where if it is all zeroes after the decimal, then it truncated.

for example, if the value is 4.000000, then the result I get is 4.

But I want the output to be 4.000000




Quote:
Originally Posted by RudiC
Welcome to the forum.

For your problem, try
Code:
awk -F "|" '{a[$2$3$4$5$6$7]+=$8;}END{for(i in a)print i"|"a[i];}' CONVFMT="%.6f" file1
ACCT1  XX  00548  02/13/2018 548JN4 L |18.424000
ACCT2  XY  00551  02/13/2018 540JC7 L |315.809000
ACCT3  XX  00639  02/13/2018 368024 L |4
ACCT5  XY  00663  02/13/2018 5210E1 L |18.344000
ACCT4  XX  00652  02/13/2018 546QD4 L |35.212000

 

9 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. Shell Programming and Scripting

Decimal places

i need to multiplay a number with 1.00.. so that the output should contain two decimal places at end.. for example... 236 * 1.00 = 236.00 245.8 * 1.00 = 245.80 but when i perform multiplication it shows output as. 236 245.8 can anyone help me to get the actual output of... (11 Replies)
Discussion started by: arunmanas
11 Replies

5. 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

6. 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

7. 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

8. 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

9. 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

LEARN ABOUT ULTRIX

tbl

tbl(1)							      General Commands Manual							    tbl(1)

Name
       tbl - format tables for nroff or *roff

Syntax
       tbl [files...]

Description
       The  preprocessor  is used for formatting tables for or The input files are copied to the standard output, except for lines between .TS and
       .TE command lines, which are assumed to describe tables and are reformatted.

Options
       -TX     Produces output without fractional line motions.  Use when the destination output device or printer or  post-filter  cannot  handle
	       fractional line motions.

       -ms     Reads in macros prior to table formatting.

       -mm     Reads in the macros prior to table formatting, if your system has the macros installed.

Examples
       As an example, letting 	 represent a tab (which should be typed as a genuine tab) the input

	      .TS
	      c s s
	      c c s
	      c c c
	      l n n.
	      Household Population
	      Town	Households
	      	Number	Size
	      Bedminster	789	3.26
	      Bernards Twp.	3087	3.74
	      Bernardsville	2018	3.30
	      Bound Brook	3425	3.04
	      Branchburg	1644	3.49
	      Bridgewater	7897	3.81
	      Far Hills	240	3.19
	      .TE

       yields

		  Household Population
		  Town	       Households
			      Number   Size
	      Bedminster	789    3.26
	      Bernards Twp.    3087    3.74
	      Bernardsville    2018    3.30
	      Bound Brook      3425    3.04
	      Branchburg       1644    3.49
	      Bridgewater      7897    3.81
	      Far Hills 	240    3.19

       If  no  arguments are given, reads the standard input, so it may be used as a filter.  When is used with or the command should be first, to
       minimize the volume of data passed through pipes.

See Also
       nroff(1)
       "Tbl - A Program to Format Tables," ULTRIX Supplementary Documents, Vol. I:General User

																	    tbl(1)
All times are GMT -4. The time now is 02:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy