设为首页收藏本站
切换到宽版

 找回密码
 注册
搜索
批处理之家»论坛 › 批处理专区: BAT CMD DOS › BAT求助&讨论 › 批处理怎么用一个文件中的字符串替换另一个文件的字符串 ...
[新手上路]批处理新手入门导读[视频教程]批处理基础视频教程[视频教程]VBS基础视频教程[批处理精品]批处理版照片整理器
[批处理精品]纯批处理备份&还原驱动[批处理精品]CMD命令50条不能说的秘密[在线下载]第三方命令行工具[在线帮助]VBScript / JScript 在线参考
返回列表 发新帖
查看: 24057|回复: 4

[文本处理] 批处理怎么用一个文件中的字符串替换另一个文件的字符串？

[复制链接]
zhouyao800
发表于 2013-11-5 11:16:20 | 显示全部楼层 |阅读模式
a.txt文件如下（a.txt是系统生成的每天都变但形式是一样的）：
lk2.MSSQL7.LK2.db.yydb.~.7.001of001.20131012040736..C:\
lk2.MSSQL7.LK2.db.yydb.~.7.001of001.20131012040736..C:\
lk2.MSSQL7.LK2.db.yydb.~.7.001of001.20131012040736..C:\
lk2.MSSQL7.LK2.db.yydb.~.7.001of001.20131012040736..C:\
lk2.MSSQL7.LK2.db.yydb.~.7.001of001.20131012040736..C:\
lk2.MSSQL7.LK2.db.ywdb.~.7.001of001.20131012040537..C:\
lk2.MSSQL7.LK2.db.ywdb.~.7.001of001.20131012040537..C:\
lk2.MSSQL7.LK2.db.ywdb.~.7.001of001.20131012040537..C:\
lk2.MSSQL7.LK2.db.ywdb.~.7.001of001.20131012040537..C:\
lk2.MSSQL7.LK2.db.ywdb.~.7.001of001.20131012040537..C:\
lk2.MSSQL7.LK2.db.cis.~.7.001of001.20131012040305..C:\
lk2.MSSQL7.LK2.db.cis.~.7.001of001.20131012040305..C:\
lk2.MSSQL7.LK2.db.cis.~.7.001of001.20131012040305..C:\
lk2.MSSQL7.LK2.db.cis.~.7.001of001.20131012040305..C:\
lk2.MSSQL7.LK2.db.cis.~.7.001of001.20131012040305..C:\

b.txt 如下：
OPERATION RESTORE
OBJECTTYPE DATABASE
RESTORETYPE MOVE
DATABASE "yydb"
MOVE  "yjdb_Data"
TO  "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\yjdbnew.mdf"
MOVE  "yjdb_Log"
TO  "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\yjdbnew_log.ldf"
# The following image is type: Full
NBIMAGE "lk2.MSSQL7.LK2.db.yydb.~.7.001of001.20130826123219..C"
SQLHOST "backup-YX"
NBSERVER "NBUSERVER02"

b1.txt如下：
OPERATION RESTORE
OBJECTTYPE DATABASE
RESTORETYPE MOVE
DATABASE "ywdb"
MOVE  "newksyy_Data"
TO  "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ywdb.mdf"
MOVE  "newksyy_Log"
TO  "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ywdb_log.ldf"
# The following image is type: Full
NBIMAGE "lk2.MSSQL7.LK2.db.ywdb.~.7.001of001.20130826123057..C"
SQLHOST "backup-YX"
NBSERVER "NBUSERVER02"

b2.txt如下：
OPERATION RESTORE
OBJECTTYPE DATABASE
RESTORETYPE MOVE
DATABASE "cis"
MOVE  "cis_Data"
TO  "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\cis.MDF"
MOVE  "cis_Log"
TO  "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\cis__Log.LDF"
# The following image is type: Full
NBIMAGE "lk2.MSSQL7.LK2.db.cis.~.7.001of001.20131005040303..C"
SQLHOST "backup-YX"
NBSERVER "NBUSERVER02"

现在想用批处理将a.txt中的lk2.MSSQL7.LK2.db.yydb.~.7.001of001.20131012040736..C:\这一行
（就是看这个中间含有yydb）不要最后两个字符也就是:\这两个字符不要，其它这一行复制出来粘帖出来替换b.txt中NBIMAGE后面单引号里面的内容，生成c.txt
下面的同理，将中间含有ywdb的第一行不要最后两个字符也就是:\这两个字符不要，其它这一行复制出来粘帖出来替换b1.txt中NBIMAGE后面单引号里面的内容生成c1.txt
将中间含有cis的第一行不要最后两个字符也就是:\这两个字符不要，其它这一行复制出来粘帖出来替换b2.txt中NBIMAGE后面单引号里面的内容,生成c2.txt
回复

举报

DAIC
发表于 2013-11-5 13:20:52 | 显示全部楼层
  1. @echo off
  2. call :substr yydb b.txt c.txt
  3. call :substr ywdb b1.txt c1.txt
  4. call :substr cis b2.txt c2.txt
  5. goto :eof

  7. :substr
  8. for /f "delims=" %%i in ('findstr "%1" a.txt') do (
  9.     set line=%%i
  10. )
  11. set line=%line:~0,-2%
  12. echo %line%
  13. type %2 | sed "s/NBIMAGE.*/NBIMAGE\"%line%\"/" > %3
复制代码
回复

举报

zhouyao800
 楼主| 发表于 2013-11-6 10:40:33 | 显示全部楼层
昨晚试了一下是可以的，但今天早上系统生成的a.txt变成了这样
k2.MSSQL7.LK2.db.yydb.~.7.001of001.20131012040736..C:\
lk2.MSSQL7.LK2.db.yydb.~.7.001of001.20131012040736..C:\
lk2.MSSQL7.LK2.db.yydb.~.7.001of001.20131012040736..C:\
lk2.MSSQL7.LK2.db.yydb.~.7.001of001.20131012040736..C:\
lk2.MSSQL7.LK2.db.yydb.~.7.001of001.20131012040736..C:\
lk2.MSSQL7.LK2.db.ywdb.~.7.001of001.20131012040537..C:\
lk2.MSSQL7.LK2.db.ywdb.~.7.001of001.20131012040537..C:\
lk2.MSSQL7.LK2.db.ywdb.~.7.001of001.20131012040537..C:\
lk2.MSSQL7.LK2.db.ywdb.~.7.001of001.20131012040537..C:\
lk2.MSSQL7.LK2.db.ywdb.~.7.001of001.20131012040537..C:\
lk2.MSSQL7.LK2.db.cis.~.7.001of001.20131012040305..C:\
lk2.MSSQL7.LK2.db.cis.~.7.001of001.20131012040305..C:\
lk2.MSSQL7.LK2.db.cis.~.7.001of001.20131012040305..C:\
lk2.MSSQL7.LK2.db.cis.~.7.001of001.20131012040305..C:\
lk2.MSSQL7.LK2.db.cis.~.7.001of001.20131012040305..C:\
再试就不行了，他自动复制替换的不是第一行的了，替换成了下面的了，大神能给帮忙看下吗？
回复

举报

zhouyao800
 楼主| 发表于 2013-11-6 10:41:01 | 显示全部楼层
回复 2# DAIC

昨晚试了一下是可以的，但今天早上系统生成的a.txt变成了这样
k2.MSSQL7.LK2.db.yydb.~.7.001of001.20131012040736..C:\
lk2.MSSQL7.LK2.db.yydb.~.7.001of001.20131012040736..C:\
lk2.MSSQL7.LK2.db.yydb.~.7.001of001.20131012040736..C:\
lk2.MSSQL7.LK2.db.yydb.~.7.001of001.20131012040736..C:\
lk2.MSSQL7.LK2.db.yydb.~.7.001of001.20131012040736..C:\
lk2.MSSQL7.LK2.db.ywdb.~.7.001of001.20131012040537..C:\
lk2.MSSQL7.LK2.db.ywdb.~.7.001of001.20131012040537..C:\
lk2.MSSQL7.LK2.db.ywdb.~.7.001of001.20131012040537..C:\
lk2.MSSQL7.LK2.db.ywdb.~.7.001of001.20131012040537..C:\
lk2.MSSQL7.LK2.db.ywdb.~.7.001of001.20131012040537..C:\
lk2.MSSQL7.LK2.db.cis.~.7.001of001.20131012040305..C:\
lk2.MSSQL7.LK2.db.cis.~.7.001of001.20131012040305..C:\
lk2.MSSQL7.LK2.db.cis.~.7.001of001.20131012040305..C:\
lk2.MSSQL7.LK2.db.cis.~.7.001of001.20131012040305..C:\
lk2.MSSQL7.LK2.db.cis.~.7.001of001.20131012040305..C:\
再试就不行了，他自动复制替换的不是第一行的了，替换成了下面的了，大神能给帮忙看下吗？
回复

举报

DAIC
发表于 2013-11-6 13:36:48 | 显示全部楼层
回复 4# zhouyao800
  1. @echo off
  2. call :substr yydb b.txt c.txt
  3. call :substr ywdb b1.txt c1.txt
  4. call :substr cis b2.txt c2.txt
  5. goto :eof

  7. :substr
  8. for /f "delims=" %%i in ('findstr "%1" a.txt') do (
  9.     set line=%%i
  10.     goto :next
  11. )

  13. :next
  14. set line=%line:~0,-2%
  15. echo %line%
  16. type %2 | sed "s/NBIMAGE.*/NBIMAGE\"%line%\"/" > %3
复制代码
回复

举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

Archiver|手机版|小黑屋|批处理之家 ( 渝ICP备10000708号 )

GMT+8, 2026-4-25 08:50

Powered by Discuz! X3.5

© 2001-2026 Discuz! Team.

快速回复 返回顶部 返回列表