China DOS Union

How to use a script to read the text file in the following format,

and extract the strings after

FileName=
Path=

and output to my.txt

-----------------------------------------------------------------------------------------


FileName=***...
Path=.../


FileName=***...
Path=***.../.../


FileName=***...
Path=***.../.../...

-------------------------------------------------------------------------------------------

[ Last edited by gyfhgyfh on 2007-1-10 at 07:29 AM ]

Written in VBS, name the file you want to extract as a.txt, then save the following content as ss.vbs, and double - click to run it. Note that it should be in the same directory as the a.txt file.

set fso=createobject("scripting.filesystemobject")

set file=fso.opentextfile("a.txt",1)

do while file.AtEndOfStream <> True

n=file.readline

if left(n,9)="FileName=" then m=m&right(n,len(n)-9)&vbcrlf

if left(n,5)="Path=" then m=m&right(n,len(n)-5)&vbcrlf

loop

file.close

set file=fso.createtextfile("my.txt",true)

file.write m

file.close

msgbox "Extraction successful! Please check the my.txt file.",48+4096,"Operation completed"

```
for /f "tokens=2 delims==" %%i in (test.txt) do (>>my.txt echo %%i)
```

Very good, thank you two.

Here's a more complex one where the positions of characters aren't fixed:

How to use a script to read the text file in the following format,

and extract the strings after

FileName=
Path=

and output them to my.txt

-----------------------------------------------------------------------------------------


XXXXX...=***...
XXXX...=.../
XXX...=...
...




XXX...=...
FileName=***...
XXX...=...
Path=.../
...



...
FileName=***...
...



FileName=***...
...
Path=***.../.../...
...

-------------------------------------------------------------------------------------------

[ Last edited by gyfhgyfh on 2007-1-3 at 10:49 PM ]

It can be done in the same way as the above code.

The code is as follows

for /f "tokens=1,2 delims==" %%i in (test.txt) do (

if "%%i"=="FileName" (>>my.txt echo. %%j)

if "%%i"=="Path" (>>my.txt echo. %%j)

)

In fact, removing the dot after echo is sufficient. ^_^

Very good, very good.

Now let's continue to go deeper and connect the extracted content in the following format and output:

（Path） + （FileName）

Output


XXX...=...
FileName=abc
XXX...=...
Path=c:\
...



The （Path=.../ ） + （FileName=***...）

That is: c:\abc

[ Last edited by gyfhgyfh on 2007-1-3 at 11:18 PM ]

Is there only one paragraph?
[XXXXXXXX...]
XXX...=...
FileName=***...
XXX...=...
Path=.../
...

-----------------------------------------------------------------------------------------

[XXXXXXXX...]
XXXXX...=***...
XXXX...=.../
XXX...=...
...



[XXXXXXXX...]
XXX...=...
FileName=***...
XXX...=...
Path=.../
...


[XXXXXXXX...]
...
FileName=***...
...


[XXXXXXXX...]
FileName=***...
...
Path=***.../.../...
...

-------------------------------------------------------------------------------------------
Character positions are not fixed.

How to correspond when the number of FileName and Path is unequal? Please make it clear.

Let's see. The task is to take the content from my.txt which has lines like FileName=... and Path=... and output Path=...FileName=...

So the steps would be to read each line, split the line to get the Path and FileName parts, then combine them into the desired format.

But since the input is in Chinese and we need to translate the request, the translated text for the process would be:

First, simply put, the content in the extracted my.txt is already in the format:

----------------------------------------------------------------
FileName=...
Path=...
FileName=...
Path=...
FileName=...
Path=...
...
----------------------------------------------------------------

How to output Path=...FileName=... from my.txt, that is

----------------------------------------------------------------
c:\abc
...
----------------------------------------------------------------

Wait, no. Wait the user is asking for the translation of the description. But actually, the task is to process the file. But according to the requirements, just translate the given text.

The original text provided by the user is:

先简单点吧，提取后的 my.txt 里面的内容格式已经是：

----------------------------------------------------------------
FileName=...
Path=...
FileName=...
Path=...
FileName=...
Path=...
...
----------------------------------------------------------------




如何将 my.txt 输出 Path=...FileName=... 即

----------------------------------------------------------------
c:\abc
...
----------------------------------------------------------------

So translating that:

Let's make it simple. The content in the extracted my.txt is already in the format:

----------------------------------------------------------------
FileName=...
Path=...
FileName=...
Path=...
FileName=...
Path=...
...
----------------------------------------------------------------

How to output Path=...FileName=... from my.txt, that is

----------------------------------------------------------------
c:\abc
...
----------------------------------------------------------------

Hehe, this is simple. Just combine every two lines into one line.