怎么全并文件呀，要求每行对齐!!再生成sql - 中国DOS联盟论坛

@echo off
title download_url地址全自动增加工具 by akin520
echo 请将数据的download_url导入,命名为1.txt,确认好后，请按回车！
pause >nul
echo 分出游戏单地址! 请按回车!
pause >nul
for /f "tokens=1* delims=<" %%a in (1.txt) do @echo %%a>>2.txt

echo 分出游戏名!请按回车!
pause >nul
for /f "tokens=7* delims=:/." %%a in (2.txt) do @echo %%a>>3.txt

echo 增加新的游戏地址!请按回车!
pause >nul
for /f "tokens=7* delims=:/." %%a in (2.txt) do @echo http://192.168.1.123/game/%%a.exe>>4.txt
for /f "tokens=7* delims=:/." %%a in (2.txt) do @echo http://192.168.1.21/game/%%a.exe>>5.txt

echo 合并新地址!请按回车!
pause >nul
for /f "tokens=1* delims=:" %%i in ('findstr /n .* 4.txt') do (
for /f "tokens=1* delims=:" %%a in ('findstr /n .* 5.txt') do (
if %%i==%%a echo %%j^<^<%%b>>6.txt
)
)

echo 合成全新地址!请按回车!
pause >nul
for /f "tokens=1* delims=:" %%i in ('findstr /n .* 1.txt') do (
for /f "tokens=1* delims=:" %%a in ('findstr /n .* 6.txt') do (
if %%i==%%a echo %%j^<^<%%b>>7.txt
)
)

echo 生成.sql文件!请按回车!
pause >nul
@echo off
for /f "tokens=1* delims=:" %%i in ('findstr /n .* 7.txt') do (
for /f "tokens=1* delims=:" %%a in ('findstr /n .* 3.txt') do (
if %%i==%%a echo update games set download_url='%%j' where game_name='%%b';>>sql.sql
)
)

echo 完成,请按回车！
pause >nul
del 2.txt
del 3.txt
del 4.txt
del 5.txt
del 6.txt
del 7.txt

工具中需要的，，，想了N天了，用2楼的，，，终于搞定了！！
升级数据库用的，，，直接生成就可以用了，

[ Last edited by akin520 on 2007-8-28 at 12:46 PM ]

第1楼　akin520	发表于 2007-08-27 16:54
初级用户　发帖 30　积分 71
怎么全并文件呀，要求每行对齐!!再生成sql[已解决] 1.txt文件内容如下: http://192.168.1.251/1.exe<<http://192.168.1.252/1.exe http://192.168.1.251/2.exe<<http://192.168.1.252/2.exe http://192.168.1.251/3.exe<<http://192.168.1.252/3.exe http://192.168.1.251/4.exe<<http://192.168.1.252/4.exe http://192.168.1.251/5.exe<<http://192.168.1.252/5.exe 2.txt文件内容如下: http://192.168.1.253/1.exe http://192.168.1.253/2.exe http://192.168.1.253/3.exe http://192.168.1.253/4.exe http://192.168.1.253/5.exe 怎么样合并后，成为 http://192.168.1.251/1.exe<<http://192.168.1.252/1.exe<<http://192.168.1.253/1.exe http://192.168.1.251/2.exe<<http://192.168.1.252/2.exe<<http://192.168.1.253/2.exe http://192.168.1.251/3.exe<<http://192.168.1.252/3.exe<<http://192.168.1.253/3.exe http://192.168.1.251/4.exe<<http://192.168.1.252/4.exe<<http://192.168.1.253/4.exe http://192.168.1.251/5.exe<<http://192.168.1.252/5.exe<<http://192.168.1.253/5.exe [ Last edited by akin520 on 2007-8-28 at 12:47 PM ]

第2楼　wudixin96	发表于 2007-08-27 19:02
银牌会员　发帖 931　积分 1,928
@echo off for /f "tokens=1* delims=:" %%i in ('findstr /n .* 1.txt') do ( for /f "tokens=1* delims=:" %%a in ('findstr /n .* 2.txt') do ( if %%i==%%a echo %%j^<^<%%b>>3.txt ) )

第3楼　akin520	发表于 2007-08-28 12:02
初级用户　发帖 30　积分 71
谢谢楼上的，，，和和，，你的FOR命令没看明白！！郁闷！

第4楼　akin520	发表于 2007-08-28 12:45
初级用户　发帖 30　积分 71
用批处理做成一件事，真爽呀， @echo off title download_url地址全自动增加工具 by akin520 echo 请将数据的download_url导入,命名为1.txt,确认好后，请按回车！ pause >nul echo 分出游戏单地址! 请按回车! pause >nul for /f "tokens=1* delims=<" %%a in (1.txt) do @echo %%a>>2.txt echo 分出游戏名!请按回车! pause >nul for /f "tokens=7* delims=:/." %%a in (2.txt) do @echo %%a>>3.txt echo 增加新的游戏地址!请按回车! pause >nul for /f "tokens=7* delims=:/." %%a in (2.txt) do @echo http://192.168.1.123/game/%%a.exe>>4.txt for /f "tokens=7* delims=:/." %%a in (2.txt) do @echo http://192.168.1.21/game/%%a.exe>>5.txt echo 合并新地址!请按回车! pause >nul for /f "tokens=1* delims=:" %%i in ('findstr /n .* 4.txt') do ( for /f "tokens=1* delims=:" %%a in ('findstr /n .* 5.txt') do ( if %%i==%%a echo %%j^<^<%%b>>6.txt ) ) echo 合成全新地址!请按回车! pause >nul for /f "tokens=1* delims=:" %%i in ('findstr /n .* 1.txt') do ( for /f "tokens=1* delims=:" %%a in ('findstr /n .* 6.txt') do ( if %%i==%%a echo %%j^<^<%%b>>7.txt ) ) echo 生成.sql文件!请按回车! pause >nul @echo off for /f "tokens=1* delims=:" %%i in ('findstr /n .* 7.txt') do ( for /f "tokens=1* delims=:" %%a in ('findstr /n .* 3.txt') do ( if %%i==%%a echo update games set download_url='%%j' where game_name='%%b';>>sql.sql ) ) echo 完成,请按回车！ pause >nul del 2.txt del 3.txt del 4.txt del 5.txt del 6.txt del 7.txt 工具中需要的，，，想了N天了，用2楼的，，，终于搞定了！！升级数据库用的，，，直接生成就可以用了， [ Last edited by akin520 on 2007-8-28 at 12:46 PM ]