China DOS Union

To let you see the effect, make a demo code:
@echo off for /f "tokens=2 delims==" %%i in (my.txt) do call :link "%%i" pause goto :eof :link set str=%1 set "str=%str:~1,-1%" set /a num+=1 set "str=%str%%var%" set "var=%str%" if %num% equ 2 ( echo "%str%" set num=0 set str= set var= ) goto :eof

set fso=createobject("scripting.filesystemobject")
set file=fso.opentextfile("a.txt",1)
do while file.AtEndOfStream <> True
m="%%%%%%%%%%%%%%%%%"
n=file.readline
if left(n,9)="FileName=" then a=right(n,len(n)-9)&vbcrlf
if left(n,5)="Path=" then m=right(n,len(n)-5)&a
if m<>"%%%%%%%%%%%%%%%%%" then mm=mm&m
m="%%%%%%%%%%%%%%%%%"
loop
file.close
set file=fso.createtextfile("my.txt",true)
file.write mm
file.close
msgbox "提取内容成功！请查看my.txt文件。",48+4096,"操作完成"

### test.txt content is as follows:
XXXXX...=***... XXXX...=.../ XXX...=... ... XXX...=... FileName=123 XXX...=... Path=c:\ ... ... FileName=456 ... Path=d:\ FileName=789 ... Path=e:\ ...


### my.bat code is as follows:

@echo off for /f "tokens=1,2 delims==" %%i in (test.txt) do ( if "%%i"=="FileName" (>>a.txt echo %%j) if "%%i"=="Path" (>>a.txt echo %%j) ) setlocal enabledelayedexpansion for /f "delims=: tokens=1*" %%i in ('findstr /n .* a.txt') do set num=%%i && set "%%i=%%j" set str= for /l %%i in (1,1,%num%) do ( if defined str (>>my.txt echo,!%%i!!str!&& set "str=" ) else ( set "str=!%%i!" ) ) >>my.txt echo,!str!&& set "str="

Running result
The content of my.txt is as follows:
c:\123 d:\456 e:\789

Thanks to ccwan, the script provided this time is already very complete.

The function of the script is really powerful!

Thanks again to everyone.

How to solve this???

Extract text.txt
----------------------------------------------
ab.exe
2006.10.26
c:\my\
cde.com
2007.1.1
d:\
f.bat
2007.1.3
c:\
...
-----------------------------------------------

Output to list.txt
----------------------------------------------
c:\my\ab.exe 2006.10.26
d:\cde.com 2007.1.1
c:\f.bat 2007.1.3
...
-----------------------------------------------

Then extract the latest file list by comparing different list.txt
--------------------------------------------------------
c:\my\ab.exe 2006.10.26
d:\cde.com 2007.1.1
c:\f.bat 2007.1.3
...
--------------------------------------------------------

--------------------------------------------------------
c:\my\ab.exe 2007.10.26
d:\cde.com 2007.1.1
c:\f.bat 2007.1.3
...
--------------------------------------------------------


That is
--------------------------------------------------------
c:\my\ab.exe 2007.10.26
...
--------------------------------------------------------

[ Last edited by gyfhgyfh on 2007-1-5 at 02:38 AM ]

```vbscript
set fso=createobject("scripting.filesystemobject")
set file=fso.opentextfile("a.txt",1)
m=1
do while file.AtEndOfStream <> True
n=file.readline
if m=1 then
a=n
m=m+1
elseif m=2 then
a=a&" "&n
m=m+1
elseif m=3 then
a=n&a
m=1
s=s&a&vbcrlf
a=""
end if
loop
file.close
set file=fso.createtextfile("my.txt",true)
file.write s
file.close
msgbox "Extraction successful! Please check the my.txt file.",48+4096,"Operation completed"
```

I didn't understand what you meant by "then extract the latest file list by comparing different list.txt".

Brother jmz573515's code is quite good.

If you want to use batch processing to extract the content of test.txt, you can make slight modifications to the demonstration code on floor 16. Because considering that there may be special characters in the path, such as spaces, &,!, etc., when generating list.txt, the path is enclosed in quotes:
@echo off cd.>list.txt set num=0 for /f "delims=" %%i in (test.txt) do call :link "%%i" start list.txt goto :eof :link set str=%1 set "str=%str:~1,-1%" set /a num+=1 if %num% equ 2 ( set "time_=%str%" ) else ( call set "str=%%str%%%var%" set "var=%str%" ) if %num% equ 3 ( echo "%str% %time_%">>list.txt set num=0 set str= set time_= ) goto :eof

As for comparing the contents of two files, it is relatively complicated. I haven't thought of how to extract the latest record for the time being - if the records in the two list.txt are in one-to-one correspondence and only the time is different, then it is a bit easier to compare.

[ Last edited by namejm on 2007-1-4 at 02:19 PM ]

### Solution 1: Using batch script (for Windows environment)
1. First, write a batch script (for example, named `compare.bat`):
```batch
@echo off
fc A.txt B.txt > temp.txt
for /f "tokens=1,2 delims= " %%a in ('findstr "c:\\my\\ab.exe" temp.txt') do (
set "old_date=%%b"
)
for /f "tokens=1,2 delims= " %%a in ('findstr "c:\\my\\ab.exe" B.txt') do (
set "new_date=%%b"
)
if "%old_date%" LSS "%new_date%" (
echo c:\my\ab.exe %new_date%
) else (
echo c:\my\ab.exe %old_date%
)
del temp.txt
```
- Explanation:
- The `fc` command is used to compare two files, and the result is redirected to `temp.txt`.
- Then, use `findstr` to find the line containing `c:\my\ab.exe` in `temp.txt` to get the old date.
- Then, find the line containing `c:\my\ab.exe` in `B.txt` to get the new date.
- Compare the two dates, and output the one with the more recent date.

### Solution 2: Using PowerShell (for Windows environment with PowerShell installed)
1. Open PowerShell and run the following commands:
```powershell
$a = Get-Content A.txt | Where-Object {$_ -match 'c:\\my\\ab.exe'}
$b = Get-Content B.txt | Where-Object {$_ -match 'c:\\my\\ab.exe'}
$dateA = $a.Split(' ')[1]
$dateB = $b.Split(' ')[1]
$dateAObj = [DateTime]::ParseExact($dateA, 'yyyy.MM.dd', $null)
$dateBObj = [DateTime]::ParseExact($dateB, 'yyyy.MM.dd', $null)
if ($dateAObj -lt $dateBObj) {
Write-Host "c:\my\ab.exe $dateB"
} else {
Write-Host "c:\my\ab.exe $dateA"
}
```
- Explanation:
- First, use `Get-Content` to read the contents of `A.txt` and `B.txt`, and then use `Where-Object` to filter the line containing `c:\my\ab.exe`.
- Then, split the line to get the date part.
- Parse the date strings into `DateTime` objects.
- Compare the two `DateTime` objects, and output the line with the more recent date.

Using FC to compare text will output a lot of useless distracting information, and it will be very tedious to extract useful information. It is not recommended to use it for comparison.

Still that question: In different list.txt, are each record one-to-one corresponding, just with different times? If so, then it is very easy.

Originally posted by namejm at 2007-1-5 03:54:
　　Comparing text with FC will output a lot of useless interference information, and it will be very tedious to extract useful information. It is not recommended to use it for comparison.

　　In different list.txt, are each record one-to-one corresponding, just with different times? If so, then it is very easy.

As you said,

In different list.txt, each record is one-to-one corresponding. Just the times are different.

How to solve it???


listA.txt
---------------------------------
c:\my\ab.exe 2006.10.26
d:\cde.com 2007.1.1
c:\f.bat 2007.1.3
---------------------------------



listB.txt
---------------------------------
c:\my\ab.exe 2007.10.26
d:\cde.com 2007.1.1
c:\f.bat 2007.1.3
---------------------------------





　　

[ Last edited by gyfhgyfh on 2007-1-5 at 05:28 AM ]

Here is given a demonstration code for displaying the different line contents of corresponding lines of two files, which is relatively inefficient:

@echo off set num=0 for /f "delims=" %%i in ('findstr .* listA.txt') do call :comp_ "%%i" pause goto :eof :comp_ for /f "delims=" %%i in ('more +%num% listB.txt') do ( if not "%%i"==%1 echo %1 与 "%%i" 不同 set /a num+=1 goto :eof )

Thank you very much to namejm, jmz573515, ccwan for their help. Thanks.

@echo off set num=0 for /f "delims=" %%i in ('findstr .* old.txt　') do call :comp_ "%%i" goto :eof :comp_ for /f "delims=" %%i in ('more +%num% new.txt ') do ( if not "%%i"==%1 echo %%i> list.txt set /a num+=1 goto :eof )

[ Last edited by gyfhgyfh on 2007-1-5 at 06:11 AM ]