運行說明:20120917.txt是需要分析的日誌,last.csv是統計結果(使用execl開啟,方便統計、排序)。
1. [檔案] awk.zip
2. [圖片] 運行截圖.jpg
3. [圖片] 運行結果
4. [代碼]存為bat雙擊開啟即可
複製代碼 代碼如下:
@echo off
setlocal ENABLEDELAYEDEXPANSION
rem 將IP提取到ip.txt檔案
awk.exe "{a[$1]+=1;}END{for(i in a){print i;}}" 20120917.txt > ip.txt
rem 逐行讀取ip.txt檔案中的IP,並調用youdao.com的ip地址源查詢介面
del result.txt
del last.txt
del last.csv
for /f "delims=" %%k in (ip.txt) do (
set /a b+=1
wget-1.10.2.exe "http://www.youdao.com/smartresult-xml/search.s?type=ip&q=%%k" --output-document=temp.xml >nul 2>nul
echo 正在處理%%k
for /f "delims=" %%i in (temp.xml) do (
set /a num+=1
set str=%%i
set str1=">%%k,!str!<"
if !num! equ 5 (echo !str1! | strrpc "<location>" "" | strrpc "</location>" "">> result.txt)
)
set num=0
)
rem 處理result.txt引號
for /f "tokens=2 delims=>" %%z in ('type result.txt') do (
for /f "delims=<" %%z in ("%%z")do echo %%z >> last.txt
)
rem 將last.txt命名為last.csv
rename last.txt last.csv
pause