06-10-2009
I got it. I should have tried different option.
awk -F"|" '{printf "%s|%s|%.3f|%.3f|%.3f\n",$1,$2,$3,$4,$5}' filename
Thanks,
Prashant
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hell friends,
I wrote a script gets the summation of particular column using awk.
The awk output is given in scientific notation. How do I convert the scientific notation to normal.
My awk syntax : awk '{sum += $2} END { printf sum }' temprep.txt
Out put is like 1.5365e+07
I want it as... (2 Replies)
Discussion started by: maheshsri
2 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I'm need to do some addition and multiplication of scientific nottaion numbers, in the form 34.23423e-10 for example.
I was echoing the list of numbers to stdout, then using bc -l, then I find that this does not seem to work for numbers with exponential notation. Could someone help me out... (1 Reply)
Discussion started by: chugger06
1 Replies
3. Shell Programming and Scripting
Hello there,
I have a script that must be written in bash that has to deal with reading in values from a file (in scientific notation), and requires executing some mathematical operations with them. What is the easiest way to go about doing this/converting it to float to use | bc, etc.?
... (7 Replies)
Discussion started by: amit_57
7 Replies
4. UNIX for Dummies Questions & Answers
Hello All,
Hope all is well,
Suppose I have a program that extracted data into a file called: progcros.in.
I attached the file but I renamed it progcros.txt. I think that my mess up the column alignment.
Anyways,
in several columns there are numbers listed, however the numbers... (4 Replies)
Discussion started by: gingburg
4 Replies
5. Shell Programming and Scripting
wondering if anyone has any thoughts to convert the below thru a shell script
Convert decimal signalling point notation to ANSI point code notation
There is a site that does that conversion but i need to implement the solution in a shell script.....Thoughts....
OS: Solaris 9
... (4 Replies)
Discussion started by: aavam
4 Replies
6. Programming
Hi,
I am trying to read a set of numbers that are in scientific notation into a file so I can do some math on them, but when I display the array contents the numbers aren't the same as the numbers in the file.
Could someone explain why? Thanks.
int main()
{
double fArray;
... (3 Replies)
Discussion started by: Filter500
3 Replies
7. Shell Programming and Scripting
Hi everyone,
I need to convert some numbers that are written in scientific notation to normal notation.
Here is a sample line from my data file;
"1",1,-1,0,0,502,0,0.00000000000E+00,0.00000000000E+00,0.35591163544E+03,0.35591163548E+03,0.50400001928E-02,0.,-1.
first of all, my data file... (4 Replies)
Discussion started by: hayreter
4 Replies
8. Shell Programming and Scripting
hello folks,
I have few values in a log which are in scientific notation.
I am trying to convert into actual decimal format or integer but couldn't able to convert.
Values in scientific notation:
1.1662986666666665E-4
2.0946799999999998E-4
3.0741333333333333E-6
5.599999999999999E-7... (2 Replies)
Discussion started by: scriptscript
2 Replies
9. Shell Programming and Scripting
Input file:
data1 0.05
data2 1e-14
data1 1e-330
data2 1e-14
data5 2e-60
data5 2e-150
data1 4e-9
Desired output:
data2 1e-14
data1 1e-330
data2 1e-14
data5 2e-60
data5 2e-150
I would like to filter out those result that column 2 is less than 1e-10.
Command try: (1 Reply)
Discussion started by: cpp_beginner
1 Replies
10. UNIX for Beginners Questions & Answers
Hi everybody,
I have file 1 with 15 columns, I want to change the formatting of the numbers of columns 10,11 and 12 in the scientific notation.
I used the Following script:
awk '{print $10}' file1.dat | awk '{printf "%.2e\n", $1}' > file2.dat
awk '{print $11}' file1.dat | awk '{printf... (7 Replies)
Discussion started by: supernono06
7 Replies
round(3M) round(3M)
NAME
round(), roundf(), roundl(), roundw(), roundq() - round functions
SYNOPSIS
HP Integrity Server Only
DESCRIPTION
The function rounds its argument to the nearest integral value in floating-point format. An argument exactly halfway between two integers
is rounded away from zero, regardless of the current rounding direction. Rounding away from zero also applies to the functions, and
Integrity Server Only
is a version of it takes a argument and returns a result.
is a version of it takes a argument and returns a result.
is an version of it takes an argument and returns an result.
is equivalent to on HP-UX systems.
USAGE
To use these functions, compile either with the default option or with the and options.
To use (for Integrity servers) or compile also with the option.
To use these functions, make sure your program includes Link in the math library by specifying on the compiler or linker command line.
For more information, see the at the following site:
RETURN VALUE
If x is returns x.
If x is NaN, returns NaN.
may raise the inexact exception if x is non integral and finite.
ERRORS
No errors are defined.
SEE ALSO
ceil(3M), floor(3M), fabs(3M), fmod(3M), fegetround(3M), fesetround(3M), lrint(3M), llrint(3M), lround(3M), llround(3M), rint(3M),
trunc(3M), math(5), fenv(5).
STANDARDS CONFORMANCE
: ISO/IEC C99 (including Annex F, ``IEC 60559 floating-point arithmetic'')
round(3M)