
CODE: [Copy to clipboard]要求用sed或gawk等能快速处理文件的命令处理:公司部,500000,2009-6-12,2011-5-30,正常
公司部,2000000,2009-5-8,2011-5-7,次级
个贷保宁,80000,2008-4-20,2008-1-20,损失
公司部,5000000,2009-1-22,2012-1-21,正常
公司部,40000,2000-5-19,2002-5-20,可疑
个贷保宁,0,2006-1-20,2008-1-20,损失
个贷保宁,0,2008-1-21,2008-1-20,关注
个贷保宁,150000,2008-10-30,2010-10-28,次级
个贷保宁,28000,2009-9-7,2010-9-6,关注
公司部,3000000,2009-6-8,2011-5-7,正常
CODE: [Copy to clipboard]有个“缺点”:要删除的行会变成空行gawk -F, "{if($2==0||($2>50000&&$NF~/正常$/)) $0=\"\";print}" file
CODE: [Copy to clipboard]gawk -F, "{if($2==0||($2>50000&&$NF~/正常$/)) next;print}" file
CODE: [Copy to clipboard][ Last edited by DXSX on 2010-9-14 at 11:40 ]@echo off
for /f "delims=, tokens=1,2,3,4,5" %%c in (xyz.txt) do (
if not %%d GTR 500000 (if not "%%g"=="正常" echo %%c,%%d,%%e,%%f,%%g )
)
CODE: [Copy to clipboard]P处理中:gawk -F, "{($NF==\"正常\");print}" file
gawk -F, "{($NF==/正常/);print}" file
gawk -F, "($NF==\"正常\"){print}" file
gawk -F, "($NF==/正常/){print}" file
CODE: [Copy to clipboard]结果为什么是相同的?而上述第一、二个P处理与第三个又结果却不相同?gawk -F, "$2=="0"{print}" file
gawk -F, "{if($2=="0") print}" file
| 欢迎光临 中国DOS联盟论坛 (http://cndos.fam.cx/forum/) | Powered by Discuz! 2.5 |