sed -n -r "/^.*(客户 [0-9]+).*$/ {s//\1,/; N; s/\n/ /; s/^([^,]+).*(累计上传.*)/\1, \2/p}; s/(客户|累计上传|累计下载) //g w c.txt" a.txt >b.txt
复制代码

@echo off
for /f "tokens=3* delims= "  %%a in (a.txt) do (
if "%%a"=="PPPoE" (set "b=%%b")
if "%%a"=="连接时间:" (set "b1=%%b"& call :main)
)
pause
exit
:main
set "b=%b:~0,7%"
set "b1=%b1:*累计上传=累计上传%"
echo/%b%,%b1% >>b.txt
for /f "tokens=2,4,5,7*" %%c in ("%b% %b1%") do echo/%%c,%%d %%e%%f %%g >>c.txt
goto :eof
复制代码

@echo off
for /f "tokens=2,4,7 delims=, " %%a in (gb.txt) do (
set "a1=%%a" & set "a2=%%b"& set "a3=%%c"
call :leiji
)
set ci=1
:pai
set/a b2=0
set/a c3=0
for /f "tokens=1,2,3" %%a in (tmpp.txt) do (
set "a1=%%a"& set/a a2=%%b& set/a a3=%%c
call :bijiao
)

echo/ %ci%.客户 %b1% ,累计上传%b2:~,-2%.%b2:~-2%MB,累计下载%b3:~,-2%.%b3:~-2%GB >>a.txt
echo/ %ci%.客户 %c1% ,累计下载%c3:~,-2%.%c3:~-2%GB,累计上传%c2:~,-2%.%c2:~-2%MB >>b.txt
set/a ci+=1
if %ci% lss 11 goto pai
del/q tmpp.txt
echo 已经整理完毕！即将退出。 
ping -n 2 baidu.com >nul&exit

:bijiao
set/a a2=%a2%
set/a a3=%a3%
if exist a.txt (for /f "tokens=2" %%x in (a.txt) do (if %a1%==%%x goto bijiao2))
if %b2% leq %a2% (set "b1=%a1%" & set/a b2=%a2% & set/a b3=%a3%)

:bijiao2
if exist b.txt (for /f "tokens=2" %%y in (b.txt) do (if %a1%==%%y goto :eof))
if %c3% leq %a3% (set "c1=%a1%" & set/a c2=%a2% & set/a c3=%a3%)
goto :eof

:leiji
if exist tmpp.txt (for /f "tokens=1" %%z in (tmpp.txt) do (if %a1%==%%z goto :eof))
set a2=%a2:.=%
set a3=%a3:.=%
for /f "tokens=2,4,7 delims=, " %%d in (gb.txt) do (
set b1=%%d& set b2=%%e& set b3=%%f
if %a1%==%%d call :leiji2
)
echo %a1% %a2% %a3% >>tmpp.txt
goto :eof
:leiji2
set b2=%b2:.=%
set b3=%b3:.=%
set/a a2+=%b2%
set/a a3+=%b3%
goto :eof
复制代码

@echo off&setlocal enabledelayedexpansion
for /f "tokens=2,4,5,8,9 delims=,. " %%a in (gb.txt) do (
  set "up=%%b%%c"&set "down=%%d%%e"
  set /a [%%a+=up,]%%a+=down
)
call :sc "[" "MB" "上传" "a.txt"
call :sc "]" "GB" "下载" "b.txt"
del tmp&pause&exit /b
:sc
for /f "tokens=1-2 delims==[]" %%a in ('set %~1') do (
  set "str=##########%%b"
  set "%~1!str:~-10,-2!.!str:~-2! %~2=%%a"
)
set %~1#|sort /+10000 >tmp
set n=0
(for /f "tokens=1,2 delims==[]#" %%a in (tmp) do (
  echo 客户 %%b，累计%~3 %%a
  set /a n+=1
  if !n! equ 10 goto :eof
))>%4
复制代码

@echo off&setlocal enabledelayedexpansion
findstr /i "[0-9].连接时间" a.txt >$t
findstr /i "[0-9].已断开" a.txt >$u
(for /f "tokens=4,5 delims=/ " %%a in ($u) do (
  set /p ".="
  for /f "tokens=2,3 delims=," %%i in ("!.!") do echo %%a %%b,%%i,%%j
))<$t>b.txt
(for /f "tokens=2,4,5,7,8 delims= " %%a in (b.txt) do echo %%a%%b%%c%%d%%e)>c.txt
del $?
复制代码

gawk "{if ($5 != \"GB,\") {a[$2]+=$4} else {a[$2]+=$4*1024};t[a[$2]] = $2;if ($8 != \"MB,\") {m[$2]+=$7} else {m[$2]+=$7/1024};p[m[$2]] = $2}END{l=asort(a,b);asort(m,n);for(i=l;i>l-10;i--) {print t[b[i]],\"累计上传\",b[i];print p[n[i]],\"累计下载\",n[i] >\"gbb.txt\"}}" gb.txt >gba.txt
复制代码

@echo off
setlocal enabledelayedexpansion

(for /f "delims=" %%a in (a.txt) do (
  set "aa=%%a"
  for %%b in ("!aa: =" "!") do (
    set "bb=%%~b"
    if /i "!bb:~,5!"=="user=" set /p=!bb!   <nul
    if /i "!bb:~,8!"=="profile=" set /p=!bb!   <nul
    if /i "!bb:~,3!"=="cn=" set /p=!bb!   <nul
    if /i "!bb:~,13!"=="expire_since=" set /p=!bb!   <nul
  )
  echo,
))>>b.txt
复制代码

iconv -f utf-8 a.txt >a_gbk.txt
复制代码