标题: 批处理可否分数乘整数 [打印本页]
作者: qingfushuan 时间: 2007-3-23 09:21 标题: 批处理可否分数乘整数
各位老大,如何从下面的test.txt中第一列和第二列相乘把得数写入y.txt
我的p显示"运算符不存在"why?
我的p:
@echo off &setlocal enabledelayedexpansion
for /f " tokens=1* delims=, " %%a in (test.txt) do (
set /a money=%%a*%%b
echo !money!>>y.txt
)
pause
test.txt:
8.200 17000
8.200 31000
8.220 14400
8.220 5100
8.240 12000
8.240 12400
8.240 1500
8.250 20000
8.250 15500
8.250 11900
8.250 10800
8.250 17600
8.250 11800
8.250 1600
8.250 35200
8.240 3300
8.260 38500
8.240 5500
8.240 28000
8.240 43000
8.230 21800
8.220 900
8.210 4000
8.220 24700
8.210 17800
8.210 15600
8.210 3000
8.210 11200
8.210 10000
8.210 13000
8.210 20000
8.210 2300
8.210 1900
8.210 1500
8.210 3300
8.210 6500
8.210 100
8.210 3100
8.210 1000
8.210 13700
8.220 40500
8.210 2000
8.220 6300
8.210 20800
8.210 5300
8.210 400
8.210 7300
8.210 3500
8.210 22900
8.210 4000
8.210 20300
8.210 4800
8.210 7000
8.210 1000
8.210 8400
8.210 8100
8.200 2200
8.200 7700
8.200 5000
8.200 1700
8.200 2300
8.200 5000
8.200 32000
8.200 12100
8.200 1200
8.190 7000
8.190 500
8.190 2000
8.190 5000
8.190 1000
8.190 5900
8.180 7200
8.180 4300
8.180 3000
8.170 1000
8.170 5700
8.170 500
8.170 2700
8.170 5000
8.170 10400
8.160 14500
8.160 3500
8.160 1000
8.160 4000
8.160 4000
8.160 4300
8.170 2800
8.170 500
8.170 1100
8.170 5800
8.170 19700
8.180 500
8.180 44500
8.190 3700
8.190 200
8.190 21300
8.190 2000
8.200 10200
8.200 3000
8.200 3400
8.200 25900
8.200 1000
8.200 32300
8.200 900
8.200 6400
8.200 3600
8.200 88300
8.200 400
8.200 1600
8.200 2400
8.200 25200
8.200 5000
8.200 5700
8.200 1000
8.200 1900
8.200 3700
8.200 10100
8.200 8500
8.200 3400
8.190 500
8.190 10000
8.190 40000
8.200 4300
8.200 8600
8.200 38200
8.200 11300
8.190 6200
8.200 8400
8.200 300
8.200 3500
8.200 2000
8.190 3300
8.190 7800
8.200 1000
8.190 13100
8.190 1000
8.190 2200
8.190 2100
8.190 28000
8.200 1000
8.200 1000
8.200 20000
8.190 2000
8.190 4000
8.190 11300
8.190 500
8.190 5000
8.190 7200
8.200 12500
8.200 2900
8.200 3000
8.200 6600
8.200 11200
8.200 6900
8.200 5000
8.200 2700
8.200 18200
8.200 3900
8.200 6100
8.200 50900
8.200 20800
8.200 11600
8.200 20300
8.210 5300
8.200 800
8.210 20000
8.210 41900
8.200 5700
8.200 2000
8.200 3900
8.200 11200
8.200 2000
8.200 13100
8.200 16000
8.200 4400
8.200 4000
8.200 18500
8.200 2000
8.210 3300
8.210 1500
8.210 5300
8.210 10100
8.210 4000
8.210 4100
8.210 11000
8.210 1300
8.210 300
8.210 2900
8.200 11300
8.200 9000
8.200 3900
8.200 100
8.200 2300
8.200 13500
8.200 4100
8.200 9100
8.200 20600
8.200 20500
8.200 4500
8.200 4500
8.200 44500
8.200 2300
8.200 1000
8.200 5800
8.200 1000
8.200 5400
8.200 4700
8.200 28500
8.200 8100
8.200 1800
8.200 12700
8.200 9800
8.200 10200
8.200 700
8.190 5900
8.190 600
8.190 7800
8.190 500
8.200 5400
8.190 11300
8.190 11400
8.180 5200
8.180 5800
8.180 9000
8.180 3900
8.180 5700
8.180 3800
8.180 12500
8.180 6000
8.180 4300
8.180 300
8.180 22700
8.190 10000
8.190 1800
8.190 7000
8.190 1000
8.190 15000
8.190 3500
8.190 500
8.190 2600
8.190 3000
8.190 4300
8.190 10900
8.190 6800
8.190 5000
8.190 1000
8.190 11900
8.190 3000
8.190 5400
8.190 6600
8.190 3300
8.190 12100
8.190 5000
8.190 4900
8.190 2900
8.190 1000
8.190 20100
8.190 10300
8.190 3000
8.190 4100
8.190 3000
8.190 15400
8.190 11200
8.190 700
8.190 9200
8.190 1000
8.190 3800
8.190 14500
8.190 1000
8.190 4500
8.190 12400
8.190 500
8.190 2600
8.190 3400
8.190 5000
8.190 26800
8.190 900
8.190 15000
8.190 1200
8.190 3000
8.190 2000
8.190 1400
8.190 2400
8.190 7400
8.190 7100
8.180 4200
8.180 2500
8.190 500
8.190 17000
8.180 3500
8.180 1700
8.180 3000
8.180 1000
8.180 9400
8.180 2000
8.180 200
8.170 1000
8.170 6100
8.170 2200
8.170 2600
8.170 2000
8.170 6000
8.170 5300
8.170 1300
8.170 13500
8.170 1000
8.170 21900
8.170 4300
8.150 1000
8.160 19800
8.150 3900
8.150 1800
8.150 1600
8.150 1500
8.160 4000
8.160 5100
8.160 4200
8.170 1500
8.170 3200
8.170 14500
8.170 5000
8.170 2000
8.170 15800
8.170 6500
8.170 400
8.170 2000
8.170 6900
8.170 3800
8.170 6100
8.170 2500
8.170 800
8.170 1000
8.170 4100
8.180 99200
8.190 11800
8.190 2000
8.180 3600
8.180 5300
8.180 1000
8.180 5000
8.180 1000
8.180 4300
8.180 5000
8.180 7300
8.180 11000
8.180 100
8.180 1300
8.180 500
8.180 7000
8.170 4700
8.170 100
8.170 3000
8.170 900
8.170 2700
8.170 5000
8.170 10600
8.170 1800
8.180 2800
8.170 6000
8.170 3700
8.170 1300
8.170 1000
8.170 3600
8.170 13100
8.160 1000
8.160 200
8.160 2000
8.160 5200
8.160 24600
8.160 4000
8.160 3400
8.160 3900
8.160 13000
8.150 2700
8.160 52900
8.160 2700
8.150 4000
8.150 8000
8.150 1500
8.150 5100
8.150 9900
8.150 2200
8.150 12800
8.160 2000
8.160 12900
8.160 500
8.160 200
8.160 1800
8.160 1100
8.160 6800
8.160 16300
8.160 1000
8.160 5800
作者: lxmxn 时间: 2007-3-23 09:57
根据所列被乘数的特点，可以先忽略小数点，最后移位小数点即可：
@Echo off&SetLocal EnableDelayedExpansion
for /f "tokens=1-3 delims=. " %%a in (test.txt) do (
set /a menoy=%%a%%b*%%c
set menoy=!menoy:~0,-3!.!menoy:~-3!
echo/!menoy!>>new.txt
)
pause&start new.txt
for /f "tokens=1-3 delims=. " %%a in (test.txt) do (
set /a menoy=%%a%%b*%%c
set menoy=!menoy:~0,-3!.!menoy:~-3!
echo/!menoy!>>new.txt
)
pause&start new.txt
作者: qingfushuan 时间: 2007-3-23 21:12 标题: 我复制粘贴到excel了
谢谢,我用excel了,合计归总比P快,但是还是得谢谢你给的思路!!!
作者: vkill 时间: 2007-3-23 23:39
gawk "{print $1*$2}" test.txt|more>y.txt
作者: qingfushuan 时间: 2007-3-24 03:49
谢谢,感谢非常,gawk的用法我搜搜先