02-24-2009
Hi Lenny,
plz let me know the sci notation.then we can resolve your problem
Thanks
Sunil
Quote:
Originally Posted by
gingburg
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 appear like this -.98584843983494D+04 is there a program make that changes all these numbers into non sci notation. Thank you all.
Lenny
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. Shell Programming and Scripting
Hi Friends,
I have following 50,000 records in .txt file.
I need to round field 3, 4, & 5 to 3 decimal places.
11|A123|-2.64216408856E01|3.64216408856E01|4.64216408856E-01
11|A123|0|-5.64216408856E01|0
11|A123|0|0|0
11|A123|-99999999|-99999999|-99999999... (4 Replies)
Discussion started by: ppat7046
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
NEATEN(1) General Commands Manual NEATEN(1)
NAME
neaten - neaten up output columns
SYNOPSIS
neaten [ format ]
DESCRIPTION
Neaten reads from its standard input and neatens up columns separated by white space using the specified format. The format is a string
consisting of a positive integer followed by an alignment character and another integer. The alignment character is usually a decimal
point ('.'), but it can be any non-digit.
The alignment character is used as the central point of each column. The total column field width will be the number to the left of the
alignment character plus one for the alignment character itself plus the number to the right of the alignment character.
If a field does not contain the alignment character, it will be printed to the left of where the alignment character would have appeared.
If a field is too long to print within the specified format, the entire field will be printed and that row will not be aligned with the
rest.
The default format is "8.8".
EXAMPLE
To examine a file with columns of numbers:
neaten 10.8 < input | more
BUGS
Columns wider than the total width of the format specification will be printed without any separating white space.
The program does not do anything special with tabs on the input.
AUTHOR
Greg Ward
SEE ALSO
cnt(1), rcalc(1), rlam(1), total(1)
RADIANCE
11/15/93 NEATEN(1)