中国DOS联盟

It's very easy. Just change "echo variable" to "echo to the file".

Originally posted by yoyodos at 2007-9-24 01:00 PM:
It's easy, just change echo variable to echo to file.

　Hehe, thank you. I understand.

Let's study together.. Haha

@echo off

setlocal enabledelayedexpansion

cd.>tmp.txt

set /a x=0



for /f "tokens=1 delims=姓名," %%r in (ab.txt) do echo %%r>>tmp.txt

for /f "delims=" %%a in (ab.txt) do (

    set /a x+=1

    set str=%%a

    for /f "tokens=1* delims=:" %%h in ('findstr /n "." tmp.txt') do (

        set n1=%%h

            if !n1!==!x! (

                set replaced=%%i

        )

    )

    for /f "tokens=1* delims=:" %%m in ('findstr /n "." cd.txt') do (

        set n2=%%m

            if !n2!==!x! (

                set new="%%n"

            )

    )

    call :replace

)

del /q tmp.txt

pause



:replace

    set str=!str:%replaced%=%new%!

    echo !str!

I also post one, haha

@echo off

setlocal enabledelayedexpansion

cd.>tmp.txt

set /a x=0



for /f "tokens=1 delims=姓名," %%r in (ab.txt) do echo %%r>>tmp.txt

for /f "delims=" %%a in (ab.txt) do (

    set /a x+=1

    set str=%%a

    for /f "tokens=1* delims=:" %%h in ('findstr /n "." tmp.txt') do (

        set n1=%%h

            if !n1!==!x! (

                set replaced=%%i

        )

    )

    for /f "delims=" %%m in ('findstr /n "." cd.txt') do (

        set n2=%%m

            if !n2!==!x! (

                set new="%%n"

            )

    )

    call :replace

)

del /q tmp.txt

pause



:replace

    set str=!str:%replaced%=%new%!

    echo !str!

Last edited by yoyodos on 2007-9-24 at 03:02 PM ]

Originally posted by yoyodos at 2007-9-24 03:01 PM:
I'll post one too, haha

@echo off

setlocal enabledelayedexpansion

cd.>tmp.txt

set /a x=0



for /f "tokens=1 delims=姓名," %%r in (ab.txt) do echo %%r>>tmp.txt

fo ... 




Generally speaking, there are mainly 2 key points worthy of learning
1. The usage of "tokens=1 delims=", this point is very easy to get wrong many times
2. Variable replacement and extraction

If the content of ab.txt is changed from the original:
Name "Zhang San", ID '102', tel '0102211', 0, 25, 11
Name "Li Sida", ID '102', tel '0202211', 0, 25, 11
Name "Wang Er", ID '102', tel '01023311', 0, 25, 11
........


To the following:
abcd rster_www_er Name "Zhang San", ID '102', tel '0102211', 0, 25, 11
abcd rster_www_er Name "Li Sida", ID '102', tel '0202211', 0, 25, 11
abcd rster_www_er Name "Wang Er", ID '102', tel '01023311', 0, 25, 11
....


Then the above reference answer codes all need to be appropriately modified.
From this, it can be known that if you are editing a highly universal code, it is best to use the method of fuzzy search and positioning. For example, in this case, even if the length of each line of the ab.txt file and other contents change, as long as there is a field like , it can be found and replaced.
Can this be achieved?

I don't quite understand what you mean.
The idea is to replace "姓名" in each line of the string with "abcd rster_www_er 姓　名", right?
Hahaha

Originally posted by yoyodos at 2007-9-24 04:10 PM:
I don't quite understand what you mean.
The idea is to replace "Name" in each line of the string with "abcd rster_www_er 姓　名".
Is that okay?
Haha

No, what I mean is that as a highly versatile search statement, using fuzzy positioning to find is more practical than using the method of finding according to the delimiter.
For example, the content in the original ab.txt file:
Name "Zhang San", ID '102', tel '0102211', 0, 25, 11
Name "Li Sida", ID '102', tel '0202211', 0, 25, 11
Name "Wang Er", ID '102', tel '01023311', 0, 25, 11
This is very neat.
If it is not neat, it becomes:
abcd rster_www_er 姓　名　"Zhang San", ID '102', tel '0102211', 0, 25, 11
abcd, er 姓　名　"Li Sida", ID '102', tel '0202211', 0, 25, 11
abcd rster, www, r 姓　名　"Wang Er", ID '102', tel '01023311', 0, 25, 11
With such a format, the design idea of strictly finding according to the delimiter is almost unusable, and only fuzzy finding can be implemented.
In general, no matter how each line of text becomes, can be replaced in any different position in each line.

Last edited by 123cainiao on 2007-9-24 at 04:43 PM ]

Oh, just use the name as the delimiter, right? Write the names after delims=, like 姓 名, 姓 名... and you can get the following names.

Originally posted by yoyodos at 2007-9-24 05:18 PM:
Oh, just use the name as a delimiter.
Write the name after delims=, such as 姓 名, 姓 名..., and you can get the subsequent names.

Thank you for your answer. After repeated testing and appropriate adjustments, it works.
Your code has very good applicability. Thanks again!

I also come to learn
@echo off
setlocal enabledelayedexpansion
set mn=0
for /f "tokens=1* delims=," %%i in (ab.txt) do (
set data=%%i%%j
set /a mn+=1
for /f "tokens=1* delims=:" %%a in ('findstr /n .* cd.txt') do (
if !mn! EQU %%a set data=!data:%%i=姓名"%%b＂,!
)
echo !data!>>c12.txt
)
pause

Originally posted by terse at 2007-9-24 07:13 PM:
I'll also contribute a section for learning
@echo off
setlocal enabledelayedexpansion
set mn=0
for /f "tokens=1* delims=," %%i in (ab.txt) do (
set data=%%i%%j
set /a mn+=1
for ...

Among all the previous responses, terse's one has the strongest adaptability and can be fully adapted to the search and replacement of general-purpose files without modification. Only the "name" field needs to be replaced with what you want to search for.
Thank you, terse

If we extend the problem, for example, the ab.txt file has only this line:
Name "Zhang San", ID '102', tel '0102211', 0, 25, 11
Now the cd.txt file remains unchanged:
Zhao Kuo
Wang Bin
Li Ling
......
Can we replace the name after the first line in the ab.txt file and then directly copy this format to generate a file ef.txt that has exactly the same number of lines as the cd.txt file:
Name "Zhao Kuo", ID '102', tel '0102211', 0, 25, 11
Name "Wang Bin", ID '102', tel '0102211', 0, 25, 11
Name "Li Ling", ID '102', tel '0102211', 0, 25, 11
........
Here the problem is not just about replacing corresponding lines, but also involves copying, which I think will be more complicated.

@echo off
setlocal enabledelayedexpansion
for /f "tokens=1* delims=," %%i in (ab.txt) do (
set data=%%j
)
for /f "tokens=1* delims=:" %%a in (cd.txt) do (
>>c12.txt echo 姓名"%%a＂,!data!
)
pause

Terse answer is very good, ha, does 123cainiao still have questions? I also practice

Originally posted by yoyodos at 2007-9-25 02:29 PM:
Terse's answer is very good, haha, does 123cainiao still have any questions?? I'll also practice

Hehe, thank you all for your answers. Different program expressions achieve the same goal, which is worth studying carefully.
　　　Best wishes to everyone for a happy Mid-Autumn Festival and a happy family!