[文本处理] 批处理将csv文本内容按某一列排序

@echo off
if "%~1"==":" (
	for /f "tokens=1,2,* delims= " %%i in (a.csv) do (
		echo;%%j#%%i#%%k
	)
) else (
	for /f "tokens=1,2,* delims=#" %%i in (
			'call "%~f0" :^|sort'
		) do (
		echo;%%j %%i %%k
	)
	pause & exit /b
)
复制代码

type 1.csv | sort { ($_ -Split ',')[1] }, { ($_ -Split ',')[0] }
复制代码

@echo off
for /f "tokens=1-3 delims= " %%a in (a.txt) do (
echo;%%b %%a %%c
)>>temp.txt
for /f "tokens=1-3 delims= " %%i in ('sort temp.txt') do (
echo;%%j %%i %%k
)>>b.txt
复制代码

@echo off
for /f "tokens=1-3 delims= " %%1 in (a.txt)do call set #_%%2_%%random%%=%%1 %%2 %%3
(for /f "tokens=2 delims==" %%1 in ('set #_')do echo %%1)>b.txt
复制代码