中国DOS联盟

-- 联合DOS 推动DOS 发展DOS --

联盟域名：www.cn-dos.net 论坛域名：www.cn-dos.net/forum
DOS，代表着自由开放与发展，我们努力起来，学习FreeDOS和Linux的自由开放与GNU精神，共同创造和发展美好的自由与GNU GPL世界吧！

游客: 注册 | 登录 | 命令行 | 会员 | 搜索 | 上传 | 帮助 »

中国DOS联盟论坛 » DOS批处理 & 脚本技术（批处理室） » 批处理可否分数乘整数

qingfushuan
高级用户

积分 502
发帖 327
注册 2006-12-30
状态离线

『楼主』: 批处理可否分数乘整数

各位老大,如何从下面的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

2007-3-23 09:21

lxmxn
版主

积分 11386
发帖 4938
注册 2006-7-23
状态离线

『第 2 楼』:

　　根据所列被乘数的特点，可以先忽略小数点，最后移位小数点即可：
@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

2007-3-23 09:57

qingfushuan
高级用户

积分 502
发帖 327
注册 2006-12-30
状态离线

『第 3 楼』: 我复制粘贴到excel了

谢谢,我用excel了,合计归总比P快,但是还是得谢谢你给的思路!!!

2007-3-23 21:12

vkill
金牌会员

积分 4103
发帖 1744
注册 2006-1-20
来自甘肃.临泽
状态离线

『第 4 楼』:

gawk "{print $1*$2}" test.txt|more>y.txt

2007-3-23 23:39

qingfushuan
高级用户

积分 502
发帖 327
注册 2006-12-30
状态离线

『第 5 楼』:

谢谢,感谢非常,gawk的用法我搜搜先

2007-3-24 03:49

请注意：您目前尚未注册或登录，请您注册或登录以使用论坛的各项功能，例如发表和回复帖子等。

可打印版本 | 推荐给朋友 | 订阅主题 | 收藏主题

论坛跳转: