怎么將字符串中的科學(xué)計(jì)數(shù)轉(zhuǎn)化成數(shù)字

gooderpan

有一個(gè)文件file：（tab分隔）
chp    pos    ref   alle   rean1_2.0E-3    rean2_2.2E-3    rean3_3.0E-3    rean4_3.2E-2    rean5_3.5E-3    rean6_3.2E-2

想要得到的結(jié)果為：（tab分隔）
chp    pos    ref   alle   rean1_0.002    rean2_0.0022    rean3_0.003    rean4_0.032    rean5_0.0035    rean6_0.032

謝謝各位大神啦啦！請(qǐng)幫幫忙！

jason680

回復(fù) 1# gooderpan

$ awk 'BEGIN{FS=OFS="\t"}{for(n=1;n<=NF;n++){if(match($n,"(.+_)([0-9.]+E[+-]*[0-9]+)",a))$n=a[1]""a[2]+0}}1' FILE
chp        pos        ref        alle        rean1_0.002        rean2_0.0022        rean3_0.003        rean4_0.032        rean5_0.0035        rean6_0.032

   

gooderpan

大神，我運(yùn)行報(bào)錯(cuò)哦！顯示：awk: syntax error at source line 1
context is
         >>> BEGIN{FS=OFS="\t"}{for(n=1;n<=NF;n++){if(match($n,"(.+_)([0-9.]+E[+-]*[0-9]+)", <<<
awk: illegal statement at source line 1
awk: illegal statement at source line 1回復(fù) 2# jason680


   

haooooaaa

1. awk '{for(i=4;++i<=NF;){split($i,t,/_|E/);$i=sprintf("%s_%s",t[1],t[2]*10^t[3])}}1' b
   
2. chp pos ref alle rean1_0.002 rean2_0.0022 rean3_0.003 rean4_0.032 rean5_0.0035 rean6_0.032
   

復(fù)制代碼

yjh777

you can use strtonum() convert it

awk '{for(i=1;i<=NF;i++) { if ($i ~ /_/) {split($i,t,/_/); $i=sprintf("%s_%s",t[1],strtonum(t[2]))} }} 1'