Sponsored Content
Top Forums Shell Programming and Scripting Help with Round Up with 2 decimal point at specific column Post 302971918 by perl_beginner on Wednesday 27th of April 2016 03:41:34 AM
Old 04-27-2016
Help with Round Up with 2 decimal point at specific column

Input file:
Code:
USA 20.5683
UK 3.54221
Japan 2.54001
China 2.50897
Germany 2.05816
.
.

Desired output file:
Code:
USA 20.57
UK 3.54
Japan 2.54
China 2.51
Germany 2.06
.
.

Command try:
Code:
awk '{printf("%.2f\n", $2)}' Input_File > Output.tmp1
awk '{print $1"\t"}' Input_File > Output.tmp2
paste -d ' ' Output.tmp2 Output.tmp1

I able to get what I want, but the way I did.
It seems like not so "nice" Smilie
Thus just wonder whether how to specific just do 2 decimal point at specific column.

Thanks.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to get rid of decimal point?

Hi, I have input with decimal point ( 9.99 ) for hours variable hrs. I need to change it to seconds. Here is my code: secs=`/usr/ucb/echo $hrs*3600 |bc` But I don't want to see the decimal point. I can use awk to trim it if there is one. I am just wondering if there is better standard... (2 Replies)
Discussion started by: cin2000
2 Replies

2. Shell Programming and Scripting

Insert a decimal point

Hi all. Using /bin/sh on an HPUX system. I want to place a decimal in the field 2 charactors from the right (yes, converting to currency). The field lengths are variable. Here's what I'm doing: exec < filename while read FIELD1 FIELD2 do FIELD1="echo $FIELD1 | sed 'syntax that will... (4 Replies)
Discussion started by: lyoncc
4 Replies

3. Shell Programming and Scripting

Round off the a Decimal value.

HI, I have a script which is used to calculate the Memory & CPU utilization a server. memx=`ssh -l siebel1 ${f} /usr/sbin/prtconf|grep -i 'Memory size'|tr -s " "|/usr/xpg4/bin/awk -F" " '{print $3 * 1024}'` v5=`ssh -l siebel1 ${f} vmstat 1 2 | tail -1 | tr -s " " | /usr/xpg4/bin/awk -v... (3 Replies)
Discussion started by: dear_abhi2007
3 Replies

4. Shell Programming and Scripting

Insert decimal point for numbers

Hi In Unix, I have a file with some numbers like : 45600 12345 I want to insert a decimal point for these numbers based on user input. If the input is 2, the numbers should be changed to 456.00 123.45 If the input is 3, the numbers should be changed to 45.600 12.345 Can... (2 Replies)
Discussion started by: yoursdivu
2 Replies

5. Shell Programming and Scripting

round decimal values and use in loops

i have a file in which 3 values are stored like --4.72 4.42 3.86 what i wanna do is that take read each value and compare with a fixed value say 5 but cant do so as i am getting an error for the same. please check the code cat /home/nsadm/auto/Logging/uptime.txt| while read a b c do if... (2 Replies)
Discussion started by: gemnian.g
2 Replies

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

7. Shell Programming and Scripting

Unable to get the Specific column with 2 decimal place

Hi, I have an issue converting decimal places of a particular column, i am using below script to get the output, but the output is not generating in desired format. awk -F"," 'BEGIN{OFS=","}{if(NR==0)getline;if ($7 != "") {if ($7 > 0) $7=$7/100 ; {printf "%.2f"... (3 Replies)
Discussion started by: rramkrishnas
3 Replies

8. Shell Programming and Scripting

Add Delimiter after 2 decimal point for a particular column

Hi All, Please help for the following scenario where I want to add a delimiter after 2 decimal point integer. Original Line 1007937820§L§2016-12-19§000000002§2018-02-01§2050-12-01§00395§M§146713.57§00005.05000§762.59§00395§M§301223.0528§1165§2017-03-31 20:34:25 Expected Line... (12 Replies)
Discussion started by: ckwan123
12 Replies

9. Shell Programming and Scripting

Decimal field round of

Hi, I want to round of decimal numbers in comma seperated lines till 2 decimal numbers. line will be like. ... (4 Replies)
Discussion started by: vishal0746
4 Replies
GP2C(1) 							       PARI								   GP2C(1)

NAME
GP2C - The GP to C compiler DESCRIPTION
gp2c [-ghfltvydWSTGV] [-i N] [-o <file>] [-p <prefix>] [file.gp] gp2c is a program that translate GP code to C code that use the libpari library. It tries to generate code looking like the PARI source code. user option: -o <file> : Place output in file <file>. -g : Generate automatic garbage collection code. -iN: Set indentation level to N spaces (default 2). -W : Output information about global variables. -p <prefix>: Prefix user-defined symbol by <prefix> to avoid conflict. -s <suffix>: Add suffix <suffix> to GP install names of functions. -S: Assume strict declarations for functions. query options: -h : This help. -f : Dump information about functions to stderr. -l : Output the list of functions known to the compiler. -t : Output the table of types known to the compiler. -v : Output version information and exit. debugging options: -d : Increase debugging level. -y : Switch parser to debug mode. -T : Output syntactic tree in treetool format. -TT : Output syntactic tree in VCG/GRL format. -G : Generate GP code in place of C code. Don't smile. -V : Do not clean up variables. file.gp: file to be processed, default to stdin. The generated C code is output to stdout unless option -o is used. See the script gp2c-run for an automated compilation process. COPYING
Copyright 2000-2005 The PARI Group GP2C is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. There is absolutely no warranty for GP2C. AUTHOR
Bill Allombert <Bill.Allombert@math.u-bordeaux.fr> SEE ALSO
gp2c-run(1), gp2c-dbg(1), gp(1), gcc(1) GP to C compiler January 2005 GP2C(1)
All times are GMT -4. The time now is 09:01 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy