China DOS Union

There are 2 TXT files: ab.txt and cd.txt.

The content of ab.txt is as follows:
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
........

The content of cd.txt is as follows:
Zhao Kuo
Wang Bin
Li Ling
.......

Can batch processing commands be used to extract the name from each line of cd.txt to replace the name content in each line of ab.txt. So that the finally generated ab.txt file is as follows:
Name "Zhao Kuo", ID '102', tel '0102211', 0, 25, 11
Name "Wang Bin", ID '102', tel '0202211', 0, 25, 11
Name "Li Ling", ID '102', tel '01023311', 0, 25, 11
........

[ Last edited by 123cainiao on 2007-9-25 at 01:36 PM ]

It feels a bit difficult, ha, I'll take a look again

On the forum, when searching for relevant content, an article that can be referred to was found; the excerpt is as follows:

Text editing (line-by-line replacement AB text integration)

File name: A.txt
Content is as follows:
old("A")new("A")
old("A")new("A")
old("A")new("A")
old("A")new("A")
old("A")new("A")
...

File name: B.txt
Content is as follows:
good
bad
poor
...

Need to replace A line by line to
old("good")new("good")
old("bad")new("bad")
old("poor")new("poor")
....

The referenced answer:
@echo off & setlocal enabledelayedexpansion
set data=old("A")new("A")
for /f "tokens=* " %%i in (b.txt) do (
set data=!data:A=%%i!
echo !data!>>c.txt
set data=!data:%%i=A!
)
pause

But the above obviously cannot handle the problem I raised, mainly because the replacement format is different, please everyone help!

Well, it's a bit different because your file requires each string to be replaced, not a unified replacement. It's a bit difficult, haha. I'm wondering if I can figure it out.

```
@echo off
setlocal enabledelayedexpansion
for /f "tokens=1* delims=:" %%a in ('findstr /n .* ab.txt') do (
for /f "tokens=1* delims=:" %%i in ('findstr /n .* cd.txt^|find "%%a:"') do set str=%%j
set ln=%%b
call set string=%%ln:"=#%%
call set string=%%string:＂=#%%
for /f "tokens=2 delims=#" %%i in ("!string!") do set str1=%%i
call :js
)
pause
goto :eof

:js
set ln=!ln:%str1%=%str%!
echo %ln%
```

Study! So powerful

Thank you very much, wudixin96. It's really eye-opening.

This is also something that must be implemented with call, otherwise there's no way to assign a value in the replacement variable, right? Asking wudixin96 a question: What does the call in front of call set string=%%ln:"=#%% mean? Thanks!

```gawk -F "BEGIN{OFS=\"\"}{if(FNR==NR){str=$0} else { a+=1; $2=\"\x22\" str \"＂\"; print $0}}" cd.txt ab.txt```

Completely stunned...

That call has a delaying effect, and many people use it in this forum.

See the convenience of the third-party tool?? o(∩_∩)o... Haha

I still need to study, haha. Let's ask another question. What's the function of the double percent signs below?
call set string=%%ln:"=#%%
Just came to the forum to hang out, thanks

It's just to play a delaying role in cooperation with call. Let's search first. My expression ability is very poor and I can't explain it clearly

Ask for advice, I have tested and found that the content display on the DOS screen has been modified, but the ab.txt file remains unchanged. That is, the new ab.txt file was not finally generated?