[文本处理] 批处理如何根据指定条件对CSV内容进行筛选、删除、输出

@echo off&setlocal enabledelayedexpansion
findstr /v /r /c:"^[ 	]*," /c:"^王1" "000.csv">$
move $ "000.csv"&rem 覆盖原文件，注意备份
findstr /r "姓名 ^[^,]*,[1-9], ^[^,]*,1[0-9] ^[^,]*,2[0-5]" "000.csv">"001.csv"
for /f "delims=" %%a in ('more +9 "%~f0"') do set "%%a"
for /f "delims=" %%a in ('type "000.csv"') do (
    for /f "tokens=7 delims=," %%b in ("%%a") do echo;%%a,!%%b!
)
pause&exit
北京=1
福建=2
广东=3
湖南=4
复制代码

#*&cls&gawk -f "%~f0"|find /v ""&pause&exit
BEGIN{
    FS=",";csv="000.csv";
    split("北京=1,福建=2,广东=3,湖南=4",a,",");
    for(i=1;i<=length(a);i++){split(a[i],b,"=");c[b[1]]=b[2];}
    while(getline<csv>0){
        if($1&&$1!~/^[[:space:]]+$/&&$1!~/王1/){
            if($1~/姓名/||$2*1<26)print $0>"001.csv";
            print c[$7]?$0","c[$7]:$0;
        }
    }
}
复制代码