- 论坛徽章:
- 0
|
sed '1,$s/215103|/63|/g' $1 >$2_dq.txt
mv $2_dq.txt $1
sed '1,$s/215106|/66|/g' $1 >$2_dq.txt
mv $2_dq.txt $1
sed '1,$s/215121|/81|/g' $1 >$2_dq.txt
mv $2_dq.txt $1
sed '1,$s/215122|/82|/g' $1 >$2_dq.txt
mv $2_dq.txt $1
sed '1,$s/215123|/83|/g' $1 >$2_dq.txt
mv $2_dq.txt $1
sed '1,$s/215125|/85|/g' $1 >$2_dq.txt
mv $2_dq.txt $1
sed '1,$s/215128|/88|/g' $1 >$2_dq.txt
mv $2_dq.txt $1
rm $2_dq.txt 2>/dev/null
cat $1 | awk 'BEGIN { FS="|" } { printf("%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|-%.2f|%s|%s|%s|%s|%.2f|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|n","'$2'","1","21511","0",$1,"2",$2,"000","11000020","2",$9,"0.0","0.0","0.0","0.0",$10,$7," "," ","0",$14,$14,$17,$17,$16,"0.0","0.0","1","0","0","0","0","0.0","0.0","39",$1,"1","1","0","0000000000000"," ","0","SGJZ"," ","3") }' >$2_dq.txt
把下面的语句集成到AWK中
if ( $7 == "215103" ) $7="63";
else if ( $7 == "215106" ) $7="66";
cat $1 | awk 'BEGIN { FS="|" ; if ( $7 == "215103" ) $7="63"; } { printf(".........
$7个字段不进行付值还是原来的数。
[ 本帖最后由 hbczjzc 于 2005-11-15 11:31 编辑 ] |
|