CODE: [Copy to clipboard]
@echo off
setlocal enabledelayedexpansion
set List=ERP SOL WWM
for %%a in (%List%) do (
set n=
for /f "delims=" %%i in (%%a.txt) do (
set %%a_!n!=%%i
set /a n+=1
)
)
(for /f "tokens=1,2 delims=, " %%a in (原表.txt) do (
set var=%%a
if "!var:STUDY=!" neq "!var!" (
if not defined %%a (
for %%i in (!var:~^,3!) do (
for %%j in (!var:~^,3!_!%%i!) do echo %%a , %%b , !%%j!&set %%a=!%%j!
set /a %%i+=1
)
) else echo %%a , %%b , !%%a!
) else echo %%a , %%b
))>原表_new.txt
CODE: [Copy to clipboard]
@echo off
setlocal enabledelayedexpansion
set List=ERP SOL WWM
for %%a in (%List%) do (
for /f "delims=" %%i in (%%a.txt) do set %%a=!%%a! %%i
)
(for /f "tokens=1,2 delims=, " %%a in (原表.txt) do (
set var=%%a
if "!var:STUDY=!"=="!var!" (echo %%a , %%b) else (
if defined %%a (echo %%a , %%b , !%%a!) else (
for %%i in (!var:~^,3!) do (
for /f "tokens=1,*" %%1 in ("!%%i!") do (
echo %%a , %%b , %%1
set "%%a=%%1" & set "!var:~,3!=%%2"
))))))>__new.txt
[