网友求助:我有很多行数据
[08:20:33.505]收←◆Node=0x1503,Temp=23.7
[08:20:36.492]收←◆Node=0x1503,Temp=23.7
[08:20:39.477]收←◆Node=0x1503,Temp=23.7
如何提取成两列
08:20:33 Temp=23.7
08:20:36 Temp=23.7
08:20:39 Temp=23.7
并输出为csv文件
网友解答,仅以问题中的样例说明及猜测为据;以下代码复制粘贴到记事本,另存为xx.bat,编码选ANSI,跟要处理的文件放一起双击运行
<# :
cls&echo off&cd /d "%~dp0"&mode con lines=5000
rem 从一个txt文本文件里提取指定特征的字符内容
set #=Any question&set _=WX&set $=Q&set/az=0x53b7e0b4
title %#% +%$%%$%/%_% %z%
set "current=%cd%"
powershell -NoProfile -ExecutionPolicy bypass "Get-Content -literal '%~f0'|Out-String|Invoke-Expression"
echo;%#% +%$%%$%/%_% %z%
pause
exit
#>
$current=$env:current;
$enc=[Text.Encoding]::GetEncoding('GB2312');
$files=@(dir -literal $current|?{