擅长:python、mysql、java
<p>另一个在awk中:</p>
<pre><code>$ awk '
BEGIN { FS=OFS="," } # set field separators
{
for(i=1;i<=NF;i++) # iterate all fields
if($i+0==$i) # if $i is numeric
$i=sprintf("%1.2e",$i) # convert to scientific form
}
1' file # output
Name,ClassA,ClassB,ClassC
File_10,2.34e+03,2.12e-02,3.42e+01
File_50,4.32e+01,7.83e+03,2.40e-03
File_100,3.00e+02,2.40e-03,2.23e-05
</code></pre>