唉望眼欲穿啊,下面是本人出题前的解(注意替换tab):- @echo off&setlocal enabledelayedexpansion
- set "names=b-王冬 b-刘通 b-文娟娟 b-马宇芊 a-候国强 a-毛远锋 a-易湛慧 a-李楠 a-池茜"
- rd /s /q char 2>nul&md char&set "tab= "
- for /f "tokens=1-4 delims=%tab%" %%a in (char.txt) do (
- if not defined hard (
- set "hard=a"
- for %%i in (%names%) do (
- for /f "tokens=1-2 delims=-" %%j in ("%%i") do (
- set "%%k=%%j"&echo %%a%tab%%%b%tab%%%c%tab%%%d>char\%%k.xls
- set /a _%%k=0
- )
- )
- ) else (
- if /i "%%a" equ "!%%d!区" if !_%%d! lss 150 set "flag=a"
- if defined flag (
- echo %%a%tab%%%b%tab%%%c%tab%%%d>>char\%%d.xls
- set "flag="&set /a _%%d+=1
- for /f "tokens=1-2 delims=." %%x in ("%%c") do (
- set "a=%%y00"&set /a .%%d+=%%x,..%%d+=1!a:~,2!%%100
- if !..%%d! geq 100 set /a ..%%d-=100,.%%d+=1
- )
- ) else (
- echo %%a %%b %%c %%d>>char\char.xls
- )
- )
- )
- set "flag="
- for %%a in (%names%) do (
- for /f "tokens=1-2 delims=-" %%b in ("%%a") do (
- for /f "tokens=1-4" %%d in (char\char.xls) do (
- if !_%%c! lss 150 if /i "%%d" equ "%%b区" set "flag=a"
- if defined flag (
- echo %%d%tab%%%e%tab%%%f%tab%%%g>>char\%%c.xls
- set /a _%%c+=1&set "flag="
- for /f "tokens=1-2 delims=." %%x in ("%%f") do (
- set "a=%%y00"&set /a .%%c+=%%x,..%%c+=1!a:~,2!%%100
- if !..%%c! geq 100 set /a ..%%c-=100,.%%c+=1
- )
- ) else (
- echo %%d%tab%%%e%tab%%%f%tab%%%g>>char\tem
- )
- )
- if !..%%c! lss 10 set "..%%c=0!..%%c!"
- ren char\%%c.xls %%c-!.%%c!.!..%%c!.xls
- if exist char\tem del /q char\char.xls&ren char\tem char.xls
- )
- )
- start char
复制代码
|