来一个不通用的,先化为整数~
- @Echo Off & setlocal EnableDelayedExpansion
- Echo Job Money>tmp.xls
- For /F "skip=1 tokens=1,2*" %%a in (test.xls) do (
- If "%%c" neq "" (
- set "sep="
- Echo %%b[tab]%%c
- set "num=%%c000" & set "num=!num:.=!"
- If "!num:~,1!" equ "-" (set "sep=-" &set "num=!num:-=!")
- set "num=!sep!!num:~,4!"
- set /a _%%a += num
- ) else (
- Echo %%a:total[tab]!_%%a:~0,-2!.!_%%a:~2!
- )
- )>>tmp.xls
复制代码
[ 本帖最后由 pusofalse 于 2008-12-15 00:06 编辑 ] |