[文本处理] [已解决]如何根据一个文本列出的字符串替换关系式对另一个文本相应的字符串进行替换

@echo off
setlocal enabledelayedexpansion
(for /f "tokens=1-8 delims=," %%a in ('type "b.txt"') do (
    set /p StrLine=
    for /f "tokens=2 delims=," %%x in ("!StrLine!") do (
        set StrCol=%%x
    )
    echo ,%%a,%%b,!StrCol!,%%d,%%e,%%f,%%g,%%h
))<"a.txt" > "c.txt"
复制代码

@echo off
rem setlocal enabledelayedexpansion
if exist C:\"Program Files"\"aa bb"\test.txt del /q C:\"Program Files"\"aa bb"\test.txt
if exist C:\"Program Files"\"aa bb"\c.txt del /q C:\"Program Files"\"aa bb"\c.txt
set file=C:\Program Files\aa bb\a.txt
set file2=C:\Program Files\aa bb\20160818_Export_c.txt
set "tmpFile=C:\Program Files\aa bb\c.txt"
set "dirFile=C:\Program Files\aa bb\test.txt"
for /f "tokens=1,2 delims=," %%a in ("%file%") do (
for /f "tokens=*" %%i in ('type "%file2%" ^| findstr %%a') do (
echo %%i>>"%tmpFile%"
)
rem call :G_getrows "C:\Users\fan-17\Desktop\a.txt" kk
)
setlocal enabledelayedexpansion
(for /f "tokens=1-8 delims=," %%a in ('type "%tmpFile%"') do (
    set /p StrLine=
    for /f "tokens=2 delims=," %%x in ("!StrLine!") do (
        set StrCol=%%x
    )
    echo ,%%a,%%b,!StrCol!,%%d,%%e,%%f,%%g,%%h
))<"%file%" > "%dirFile%"

if exist "%tmpFile%" del /q "%tmpFile%"
复制代码

if exist "C:\Program Files\aa bb\test.txt" del /q "C:\Program Files\aa bb\test.txt"
复制代码

@echo off
set "file=C:\Program Files\aa bb\a.txt"
set "file2=C:\Program Files\aa bb\20160818_Export_c.txt"
set "tmpFile=C:\Program Files\aa bb\c.txt"
set "dirFile=C:\Program Files\aa bb\test.txt"
if exist "%tmpFile%" del /q "%tmpFile%"
if exist "%dirFile%" del /q "%dirFile%"

for /f "tokens=1,2 delims=," %%a in ("%file%") do (
    for /f "tokens=*" %%i in ('type "%file2%" ^| findstr %%a') do (
        >>"%tmpFile%" echo %%i
    )
    rem call :G_getrows "C:\Users\fan-17\Desktop\a.txt" kk
)

setlocal enabledelayedexpansion
(for /f "tokens=1-8 delims=," %%a in ('type "%tmpFile%"') do (
    set /p StrLine=
    for /f "tokens=2 delims=," %%x in ("!StrLine!") do (
        set StrCol=%%x
    )
    echo ,%%a,%%b,!StrCol!,%%d,%%e,%%f,%%g,%%h
))<"%file%" > "%dirFile%"

if exist "%tmpFile%" del /q "%tmpFile%"
复制代码

@echo off
rem 号与号的对应文件
set file=C:\Program Files\aa bb\a.txt
rem 文件
set file2=C:\Program Files\aa bb\20160818_Export_c.txt
rem 生成的临时文件，最后会删掉
set tmpFile=C:\Program Files\aa bb\c.txt
rem 生成的新的文件
set dirFile=C:\Program Files\aa bb\test.txt
if exist "%tmpFile%" del /q "%tmpFile%"
if exist "%dirFile%" del /q "%dirFile%"

for /f "tokens=1,2 delims=," %%a in ('type "%file%"') do (
    for /f "tokens=*" %%i in ('type "%file2%" ^| findstr %%a') do (
        >>"%tmpFile%" echo %%i
    )
)
setlocal enabledelayedexpansion

(for /f "tokens=1-8 delims=," %%a in ('type "%tmpFile%"') do (
    set /p StrLine=
    for /f "tokens=2 delims=," %%x in ("!StrLine!") do (
        set StrCol=%%x
    )
    echo ,%%a,%%b,!StrCol!,%%d,%%e,%%f,%%g,%%h
))<"%file%" > "%dirFile%"

if exist "%tmpFile%" del /q "%tmpFile%"
复制代码