04-25-2011
Quote:
Originally Posted by
arunmanas
Hi Kevin,
the below command works fine..
awk 'BEGIN{p=236 * 1.00; printf "%0.2f", p}'
can u please help me to apply this script for a excel sheet which contains numbers and all those number should be displayed in the above format
How does your excel sheet look like? what's your input and desired output?
Anyway, I think you should try it out yourself, you already know how to print numbers with decimal point.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
5. Shell Programming and Scripting
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
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
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
8. Shell Programming and Scripting
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
9. Shell Programming and Scripting
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 REDHAT
frontend-spec
FRONTEND-SPEC(7) FRONTEND-SPEC(7)
NAME
frontend-spec - interface between jw and its frontends
DESCRIPTION
jw(1) calls frontends like frontends/docbook to get the informations specific to a given input format. The frontend knows which information
to return from the first command line parameter. It gets all necessary data via environment variables ready to use.
This document describes that command line parameter and those environment variables.
The frontend should return 0 if there weren't any problem, and return a positive value otherwise.
VARIABLES
$1
The command line parameter, specifying which information to return. It can take the following values:
centralized-catalog
The frontend must return the DTD-specific centralized catalog name. Centralized catalogs normally reside in /etc/sgml and
provide the location of all the catalog files useful for handling this input type (the catalog for the DTD, the catalog for
the stylesheets, the catalog for the entities, ...)
style-sheet
The frontend must return the filename of the style sheet to be used for this document type and with the chosen backend.
SGML_CATALOGS_DIR
The directory where the centralized catalogs reside. It is normally /etc/sgml.
(This variable is valid only while determining the centralized catalog to use.)
SGML_BASE_DIR
The base directory of the SGML system. It is normally /usr/share/sgml.
(This variable is valid only while determining the style sheet to use.)
SGML_FILE
The name of the file to convert.
(This variable is valid only while determining the centralized catalog to use.)
SGML_TYPE
The type of the backend to use, whether it produces output files to be displayed online or to be printed out. It can take the value
html or print.
(This variable is valid only while determining the style sheet to use).
SGML_STYLESHEETS
The desired custom stylesheet type, either none or default. If none, the frontend must return the file name of the style sheet pro-
vided by the system beneath the docbook-utils. If default, the frontend must return the custom stylesheet provided by the docbook-
utils.
(This variable is valid only while determining the style sheet to use).
SGML_XML
The metalanguage of the file to convert, either sgml or xml.
(This variable is valid only while determining the centralized catalog to use).
FILES
SEE ALSO
backend-spec(7)
AUTHORS
Jochem Huhmann <joh@revier.com>
05 February 2003 FRONTEND-SPEC(7)