@echo off
setlocal enabledelayedexpansion
for /f "tokens=7,12 delims=&= " %%i in (b.txt) do set #%%j=%%i
(for /f "tokens=1* delims==" %%i in (a.txt) do echo,%%j)>Newfile.txt
findstr /g:Newfile.txt c.txt>1.log
(for /f "tokens=1* delims==" %%i in (1.log) do echo,%%j)>Newfile.txt
for /f "tokens=1-5,7 delims=- " %%a in (Newfile.txt) do set /a "_%%a%%b%%c%%d%%e%%f+=1"
(for /f "tokens=1-5,7 delims=- " %%a in (Newfile.txt) do (
    if not defined @%%a%%b%%c%%d%%e%%f (
        echo,%%f	!#%%f!	%%a-%%b-%%c-%%d-%%e	!_%%a%%b%%c%%d%%e%%f!
        set /a Sum+=!_%%a%%b%%c%%d%%e%%f!
    )
    set @%%a%%b%%c%%d%%e%%f=true
))>1.log
sort 1.log>Newfile.txt
echo,Sum	!Sum!>>Newfile.txt
del 1.log
pause
复制代码

$a='.\a.txt';
$b='.\b.txt';
$c='.\c.txt';

$hash=[Collections.Generic.HashSet[string]]::new();
$infoID = @();
(gc $a -ReadCount 0).foreach{
	$id = $_ -replace '^.*?=|\s+\d+$';
	if($hash.Add($id)){ $infoID+=$id }
}

$hash.Clear();

$user = @();
(gc $b -ReadCount 0).Foreach{
	$s = $_ -replace '^.*?=(.*?)&.*?-\s+((\d+\.){3}\d+).*$','$2,$1' -split ',';
	if($hash.Add($s[0]+$s[1])){
		$user += @{ $s[0].ToString() = $s[1]}
	}
}
$hash.Clear();

$ipCount=@();
(gc $c -ReadCount 0).Foreach{
	$s = $_ -replace '^.*?=(.*?)\s.*?-\s+((\d+\.){3}\d+).*$','$1,$2' -split ',';
	if($infoID.contains($s[0])){
		$ipCount+=[PsCustomObject]@{id=$s[0]; ip=$s[1]; name=$user."$($s[1])"; }
	}
}

($ipcount|group name).Foreach{
	$ip =$_.Group[0].ip;
	$name = $_.Name;
	$_.group|group id|%{$ip + "`t" + $name + "`t`t" + $_.Name + "`t" + $_.Count}
}


&cmd /c set/p=全部完成 退出<nul`&pause>nul;exit
复制代码

192.168.30.20   技术部_龙一a            7717F5D7-A409-4D48-9E87-1A92367C3593  1
192.168.30.20   技术部_龙一a            C8FC9543-453E-44AB-9188-FC72963689D1  1
192.168.30.20   技术部_龙一a            AAA31733-09CE-4015-A327-7C4BAC2B25EE  2
192.168.30.20   技术部_龙一a            A0C8BDE0-6A46-4128-B566-5F40D0B83299  1
192.168.30.1    技术部_郭肥来a          7717F5D7-A409-4D48-9E87-1A92367C3593  2
192.168.30.1    技术部_郭肥来a          99D32186-121E-4FF7-AB54-0F816687A0A5  1
192.168.30.1    技术部_郭肥来a          A0C8BDE0-6A46-4128-B566-5F40D0B83299  1
192.168.102.11  服务部_李四博a          7717F5D7-A409-4D48-9E87-1A92367C3593  1
192.168.102.11  服务部_李四博a          99D32186-121E-4FF7-AB54-0F816687A0A5  1
192.168.102.11  服务部_李四博a          C8FC9543-453E-44AB-9188-FC72963689D1  1
192.168.102.11  服务部_李四博a          AAA31733-09CE-4015-A327-7C4BAC2B25EE  1
192.168.29.10   人事部_肖逄文a          99D32186-121E-4FF7-AB54-0F816687A0A5  1
192.168.29.10   人事部_肖逄文a          A0C8BDE0-6A46-4128-B566-5F40D0B83299  1
192.168.37.153  工程部_张三a            99D32186-121E-4FF7-AB54-0F816687A0A5  1
192.168.37.153  工程部_张三a            C8FC9543-453E-44AB-9188-FC72963689D1  2
192.168.37.153  工程部_张三a            A0C8BDE0-6A46-4128-B566-5F40D0B83299  1
192.168.81.18   投诉部_王欣零a          AAA31733-09CE-4015-A327-7C4BAC2B25EE  1
复制代码