此题难道就这么难吗?技术组的也没看见几个来接招的!贴出本人的解,大家测试时请将标注为[TAB]的地方改为制表符:
- @echo off&setlocal enabledelayedexpansion
- for /f "tokens=1-3" %%a in ('type test.xls') do (
- if not defined flag (
- echo %%b[TAB]%%c>test.xls&set "flag=a"
- ) else (
- if "%%c" neq "" (
- for /f "tokens=1,2 delims=." %%i in ("%%c") do (
- set "a=%%i"&set "b=%%j00"&set "+=+"
- if "!a:~,1!" equ "-" set "+=-"
- set /a num1!+!=!a:-=!,num2!+!=1!b:~,2!%%100
- if !num2! geq 100 set /a num2-=100,num1+=1
- if !num2! lss 0 set /a num2+=100,num1-=1
- if !num2! lss 10 set "num2=0!num2!"
- )
- echo %%b[TAB]%%c>>test.xls
- ) else (
- echo %%a:%%b[TAB]!num1!.!num2!>>test.xls&set /a num1=0,num2=0
- )
- )
- )
复制代码
[ 本帖最后由 batman 于 2008-12-16 17:24 编辑 ] |