awk文本处理

西厢了个梦

Command Line

sql>select * from 'table1';
result
34535.0

sql>select * from 'table2';
result
1.0647789E7

sql>quit



希望得到的输出结果：
table1  34535
table2  10647789

sunzhiguolu

1. perl -nle 'if(/\b(table\d+)\b/){$P=1;$h=$1;next}if($P++>1){print "$h ",/E(\d)/?*10**$1:int($_);$P=0}' f

复制代码

table1 34535
table2 10647789

jcdiy0601

1. sed -rn "/table/{N;N;s/\n.*\n//;s/([^']*)'(.*)';(.*)/\2\n\3/;p}" file

复制代码