[文件操作] 【已解决】批处理如何删除多个文本里指定列/字段的内容为指定字符串的行

rem win7及以上系统运行
2>nul md "result\" 
powershell -c "dir *.txt|%%{gc $_|?{($_.trim() -split '\s+')[1] -ne 0}|out-file $('result\'+$_.Name) -encoding default}"
rem powershell -c "dir *.txt|%%{gc $_|?{$_ -notmatch '^\s*?\S+?\s+?0[^0]*?'}|out-file $('result\'+$_.Name) -encoding default}"
pause
复制代码

rem 请把__tab__换成实际的tab字符
set tab=__tab__
for %%a in (*.txt) do (
for /f "tokens=1,2,* delims=%tab%" %%x in (%%a) do (
if not "%%y" == "0" echo %%x%tab%%%y%tab%%%z>>%%~na_1.txt
)
)
复制代码

set tab=	
for %%a in (*.txt) do (
    for /f "tokens=1,2,* delims=%tab%" %%x in (%%a) do (
        if not "%%y" == "0" echo %%x%tab%%%y%tab%%%z>>%%~na_1.txt
    )
)
复制代码

@echo off
for /f "tokens=*" %%a in ('type "文本.txt"') do (
    for /f "tokens=1,2" %%b in ("%%a") do (
        if "%%c" equ "0" echo;%%a
    )
)
pause
复制代码

findstr /rc:"^[ 	]*[^ 	][^ 	]*[ 	][ 	]*0[^0]*" "文本.txt"
pause
复制代码

#*第三方http://www.bathome.net/s/tool/index.html?key=gawk
#*&cls&2>nul md "result\" &dir /a-d/b *.txt|gawk -f "%~f0"&pause&exit
BEGIN{
   while(getline file>0){
      while(getline<file>0){
          if($2==0)print $0>"result\\"file
      }
   }
}
复制代码