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;

Code:

"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 is a .csv and not all the numbers are in scientific notation.
the ones that are to be converted
0.35591163544E+03 will be 355.91163544 and
0.00000000000E+00 will simply be 0

I have to do this conversion through out the whole data file.

thanks a lot in advance.

Hi bipi,

thanks again for your help, this works quite good, but what about E- ??

Try this:

Code:

awk -F, ' {
        for(i=1;i<=NF;i++) {
                if($i~/E\+/)
                        $i=sprintf("%.8f",$i);
                if($i=="0.00000000")
                        $i=0;
        }
}1' OFS=, filename

If you want to consider negative as well:

Code:

if(($i~/E\+/)||($i~/E-/))

thanks a lot bipi. This works very well

Alternatively, try:

Code:

awk '{gsub(/"/,x); for(i=1; i<=NF; i++) $i=$i+0}1' CONVFMT="%.8f" FS=, OFS=, file