[文本处理] 如何将文本里每行前5位字符相同的行进行分组并找出每组中后5位数字的值最大的一个

@echo off
setlocal enabledelayedexpansion

(
    for /f %%i in (' sort /r "a.txt" ') do (
        set str=%%i
        if "!_last:~0,5!" neq "!str:~0,5!" (echo %%i)
        set _last=!str!
    )
) >"%~f0.tmp"

sort "%~f0.tmp" >result.txt
del "%~f0.tmp"
复制代码

@echo off&setlocal enabledelayedexpansion
for /f "delims=" %%a in ('type "文本.txt"') do (
    set "str=%%a"
    for /f "delims=" %%b in ("!str:~,5!") do (
        if not defined #%%b (
            set #%%b=!str:~5,5!
        ) else (
            if !str:~5^,5! geq !#%%b! set #%%b=!str:~5,5!
        )
    )
)
for /f "tokens=1,2 delims=#=" %%a in ('set #') do echo;%%a%%b
pause
复制代码

rem win7及以上系统运行
more +3 "%~f0"|powershell -c "$input|group {$_.Substring(0,5)}|%%{$_.group|sort -descending|select -first 1}"
pause&exit
I1E0000001
I1E0004997
I1E0004998
I1E0004999
I1E0005000
I1ET000001
I1ET000002
I1ET000003
I1GTC00001
I1GTC00002
I1GTC15000
复制代码