Board logo

标题: [文本处理] 求助批处理如何提取ping平均值？ [打印本页]
作者: laotou1000    时间: 2009-10-9 11:14     标题: 求助批处理如何提取ping平均值？

我编写了一个提取拼平均值的批处理代码，如下：
  1. @echo off

  2. for /l %%p in (130,1,150) do @ping 172.16.3.%%p -n 1 -w 10 | find " " /i >>旧.txt

  3. (for /f "tokens=1,2,6 delims== " %%i in ('findstr /i "Pinging Average" 旧.txt') do if /i "%%i" == "Pinging" (set /p =%%j:<nul) else set /p =Average=%%k<nul&echo.)>>新.txt

  4. pause
复制代码
运行结果如下：
  1. 旧.txt

  2. 

  3. Pinging 172.16.3.130 with 32 bytes of data:

  4. 

  5. Reply from 172.16.3.130: bytes=32 time=58ms TTL=64

  6. 

  7. Ping statistics for 172.16.3.130:

  8. 

  9.     Packets: Sent = 1, Received = 1, Lost = 0 (0% loss),

  10. 

  11. Approximate round trip times in milli-seconds:

  12. 

  13.     Minimum = 58ms, Maximum = 58ms, Average = 58ms

  14. 

  15. Pinging 172.16.3.131 with 32 bytes of data:

  16. 

  17. Request timed out.

  18. 

  19. Ping statistics for 172.16.3.131:

  20. 

  21.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  22. 

  23. Pinging 172.16.3.132 with 32 bytes of data:

  24. 

  25. Reply from 172.16.3.132: bytes=32 time<1ms TTL=128

  26. 

  27. Ping statistics for 172.16.3.132:

  28. 

  29.     Packets: Sent = 1, Received = 1, Lost = 0 (0% loss),

  30. 

  31. Approximate round trip times in milli-seconds:

  32. 

  33.     Minimum = 0ms, Maximum = 0ms, Average = 0ms

  34. 

  35. Pinging 172.16.3.133 with 32 bytes of data:

  36. 

  37. Request timed out.

  38. 

  39. Ping statistics for 172.16.3.133:

  40. 

  41.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  42. 

  43. Pinging 172.16.3.134 with 32 bytes of data:

  44. 

  45. Request timed out.

  46. 

  47. Ping statistics for 172.16.3.134:

  48. 

  49.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  50. 

  51. Pinging 172.16.3.135 with 32 bytes of data:

  52. 

  53. Request timed out.

  54. 

  55. Ping statistics for 172.16.3.135:

  56. 

  57.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  58. 

  59. Pinging 172.16.3.136 with 32 bytes of data:

  60. 

  61. Request timed out.

  62. 

  63. Ping statistics for 172.16.3.136:

  64. 

  65.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  66. 

  67. Pinging 172.16.3.137 with 32 bytes of data:

  68. 

  69. Request timed out.

  70. 

  71. Ping statistics for 172.16.3.137:

  72. 

  73.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  74. 

  75. Pinging 172.16.3.138 with 32 bytes of data:

  76. 

  77. Request timed out.

  78. 

  79. Ping statistics for 172.16.3.138:

  80. 

  81.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  82. 

  83. Pinging 172.16.3.139 with 32 bytes of data:

  84. 

  85. Request timed out.

  86. 

  87. Ping statistics for 172.16.3.139:

  88. 

  89.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  90. 

  91. Pinging 172.16.3.140 with 32 bytes of data:

  92. 

  93. Request timed out.

  94. 

  95. Ping statistics for 172.16.3.140:

  96. 

  97.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  98. 

  99. Pinging 172.16.3.141 with 32 bytes of data:

  100. 

  101. Request timed out.

  102. 

  103. Ping statistics for 172.16.3.141:

  104. 

  105.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  106. 

  107. Pinging 172.16.3.142 with 32 bytes of data:

  108. 

  109. Request timed out.

  110. 

  111. Ping statistics for 172.16.3.142:

  112. 

  113.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  114. 

  115. Pinging 172.16.3.143 with 32 bytes of data:

  116. 

  117. Reply from 172.16.3.143: bytes=32 time=1ms TTL=128

  118. 

  119. Ping statistics for 172.16.3.143:

  120. 

  121.     Packets: Sent = 1, Received = 1, Lost = 0 (0% loss),

  122. 

  123. Approximate round trip times in milli-seconds:

  124. 

  125.     Minimum = 1ms, Maximum = 1ms, Average = 1ms

  126. 

  127. Pinging 172.16.3.144 with 32 bytes of data:

  128. 

  129. Request timed out.

  130. 

  131. Ping statistics for 172.16.3.144:

  132. 

  133.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  134. 

  135. Pinging 172.16.3.145 with 32 bytes of data:

  136. 

  137. Request timed out.

  138. 

  139. Ping statistics for 172.16.3.145:

  140. 

  141.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  142. 

  143. Pinging 172.16.3.146 with 32 bytes of data:

  144. 

  145. Request timed out.

  146. 

  147. Ping statistics for 172.16.3.146:

  148. 

  149.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  150. 

  151. Pinging 172.16.3.147 with 32 bytes of data:

  152. 

  153. Request timed out.

  154. 

  155. Ping statistics for 172.16.3.147:

  156. 

  157.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  158. 

  159. Pinging 172.16.3.148 with 32 bytes of data:

  160. 

  161. Request timed out.

  162. 

  163. Ping statistics for 172.16.3.148:

  164. 

  165.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  166. 

  167. Pinging 172.16.3.149 with 32 bytes of data:

  168. 

  169. Request timed out.

  170. 

  171. Ping statistics for 172.16.3.149:

  172. 

  173.     Packets: Sent = 1, Received = 0, Lost = 1 (100% loss),

  174. 

  175. Pinging 172.16.3.150 with 32 bytes of data:

  176. 

  177. Reply from 172.16.3.150: bytes=32 time=1ms TTL=128

  178. 

  179. Ping statistics for 172.16.3.150:

  180. 

  181.     Packets: Sent = 1, Received = 1, Lost = 0 (0% loss),

  182. 

  183. Approximate round trip times in milli-seconds:

  184. 

  185.     Minimum = 1ms, Maximum = 1ms, Average = 1ms
复制代码
  1. 新.txt

  2. 

  3. 172.16.3.130:Average=58ms

  4. 

  5. 172.16.3.131:172.16.3.132:Average=0ms

  6. 

  7. 172.16.3.133:172.16.3.134:172.16.3.135:172.16.3.136:172.16.3.137:172.16.3.138:172.16.3.139:172.16.3.140:172.16.3.141:172.16.3.142:172.16.3.143:Average=1ms

  8. 

  9. 172.16.3.144:172.16.3.145:172.16.3.146:172.16.3.147:172.16.3.148:172.16.3.149:172.16.3.150:Average=1ms
复制代码
现在我想要将 新.txt 中的显示内容修改为
  1. 172.16.3.130:Average=58ms

  2. 172.16.3.131:

  3. 172.16.3.132:Average=0ms

  4. 172.16.3.133:

  5. 172.16.3.134:

  6. 172.16.3.135:

  7. 172.16.3.136:

  8. 172.16.3.137:

  9. 172.16.3.138:

  10. 172.16.3.139:

  11. 172.16.3.140:

  12. 172.16.3.141:

  13. 172.16.3.142:

  14. 172.16.3.143:Average=1ms

  15. 172.16.3.144:

  16. 172.16.3.145:

  17. 172.16.3.146:

  18. 172.16.3.147:

  19. 172.16.3.148:

  20. 172.16.3.149:

  21. 172.16.3.150:Average=1ms
复制代码
即每个IP后面跟一个平均值，而且一个IP一行，我应该如何修改代码？请各位前辈指教。

[ 本帖最后由 laotou1000 于 2009-10-9 11:16 编辑 ]
作者: hlzj88    时间: 2009-10-9 23:22

看这个贴挂了12小时，没人发言，我就说一下我的理解，因为写不出
set /p =%%j:<nul  可能是这句导致后面新.txt数据连续
Average = 1ms  如果要取这句，可以 skip=n 掉前面的几行 用delims或findstr来截取到Average = 1ms(也可以截取TTL) 再set a后得到 1（先去掉Average = ）（再倒过来截去掉ms）  ，再set b先等于0，令set b=(set a)+b(这里的b是多个a相加)，再除以（150-130）就是你要的平均值,貌似不用写入文本，关键在截取到数字

不会说，希望我的思路你能理解。
作者: laotou1000    时间: 2009-10-10 09:21     标题: 回复 2楼 的帖子

感谢hlzj88的热心帮助！！！
不过在“再set b先等于0，令set b=(set a)+b(这里的b是多个a相加)，再除以（150-130）就是你要的平均值”中，为什么要让多个a相加，再除以（150-130）呢？
作者: hlzj88    时间: 2009-10-10 20:32

a 是每次ping得到的数，b是每次a的值相加的和，（150-130）是你ping的总次数。

刚在线翻译了一下。Average为平均，哈哈，英语不行，就是不行。各位见笑了。

[ 本帖最后由 hlzj88 于 2009-10-10 20:38 编辑 ]
作者: laotou1000    时间: 2009-10-12 08:53     标题: 回复 4楼 的帖子

您好像弄错了吧？我要的不是您说的这个，我是想要从ping的结果中提取其中的average。
作者: duanlihong    时间: 2009-11-23 14:35     标题: 请参考

  1. @echo off&setlocal enabledelayedexpansion

  2. echo *****************************监测启动****************************************

  3. cd c:\

  4. for /f "tokens=1* delims=：" %%a in (a.txt) do (

  5.     for /f  "tokens=3 delims=," %%i in ('ping -l 1000 -n 2 %%a ^|findstr Average') do echo %%a %%i>>ping.txt

  6.     )

  7. pause
复制代码




欢迎光临 批处理之家 (http://bathome.net./) Powered by Discuz! 7.2