windows下,给一个目录下所有.sql的文件内容中,开头和结尾批量添加文件名,批处理文件也怎么写
addfile_name.bat
@echo off
setlocal enabledelayedexpansion
set "directory=D:\test\test"
set "header=-- File: "
set "footer=-- End of file: "
for %%F in ("%directory%\*.sql") do (
set "filename=%%~nxF"
set "outputfile=%%~dpnF_output.sql"
echo %header%!filename! > "!outputfile!"
type "%%F" >> "!outputfile!"
echo %footer%!filename! >> "!outputfile!"
echo. >> "!outputfile!"
move /y "!outputfile!" "%%F" > nul
)
echo Done!