Hi RudiC,

I just try with your awk command.
It return something as below:

Code:

awk '{$1=$1+0}1' OFMT="%.8f" file
0.0001757
0.00751
5.634e-05

The output result is different from what I expected.
Apart from that, is it possible your command work for something like "1.757E-100" and return "7.51E-3" as "0.00751" instead of "0.00751000".

Really thanks and sorry for troubling you.

---------- Post updated at 09:04 AM ---------- Previous update was at 08:57 AM ----------

Hi Klashxx,

I just try your python script with the data set.
But it return the following error message:

Code:

  File "./num.py", line 9
    except Exception,err:
    ^
IndentationError: unexpected indent

Is there something wrong with my python program?
Thanks for advice.