请教bat批处理，文件名或其存放路径名含有空格，需替换字符串也带有空格

qspringleaf · 发表于 2021-10-4 18:26:27

致论坛的老师&大神：

请教关于bat批处理，有两个地方的空格导致不知该如何解决，1，待处理的文件名或其存放路径名含有空格，2.需要替换文件里边内容，该内容是带有空格的字符串。搜变全网没找到都满足的解决方案。

比方说有一个txt文档，他的文件名是: address update.txt,文件名或其存放路径名含有空格，
要替换的内容为: 000- woodlands drive 79,想将文本内所有的该字符串替换为 000- sembawang street 66

address update.txt文本内容如下：

Update = Open( Concat( New_path, "000- woodlands drive 79.csv" ) );
Update << select where( :RAW_VALUE == 0 );
Update << Delete Rows;
Update << New Column( "Batch",
Character,
Nominal,
Formula(
If(
Contains( :ID, "ID001" ), "001",
Contains( :ID, "ID002" ), "002",
)
)
);
Update << Move Selected Columns({“Batch”}, To First);
Column( Update, "shift ID" ) << data type( Character );
Column( Update, "shift ID" ) << Set Modeling Type( Nominal );
Column( Update, "shift ID" ) << set name( "Batch ID" );
For Each Row(
Update,
:Batch ID = Match( :Batch ID,
"9653856", "shift1",
"9673409", "shift2",
"9653427", "shift1",
"9663511", "shift2",
"9653427", "shift1",
"9663550", "shift2",
"Unspecified"
)
);
Update << New Column( "rename",
Character,
Nominal,
Formula(
If(
Contains( :address, "param1" ), "000- woodlands drive 79",
Contains( :address, "param2" ), "000- woodlands drive 79",
Contains( :address, "param3" ), "000- woodlands drive 79",
Contains( :address, "param4" ), "000- woodlands drive 79",
Contains( :address, "param5" ), "000- woodlands drive 79",
Contains( :address, "param6" ), "000- woodlands drive 79",
)
)
);
dtWaferLevel = Update << Split(
Split By( :rename ),
Split( :RAW_VALUE ),
Group(
:Batch,
:Category,
:LOT_ID,
:Batch ID,
),
Remaining Columns( Drop All )
);

复制代码

idwma · 发表于 2021-10-4 19:08:48

@echo off
setlocal enabledelayedexpansion
for /f "tokens=1* delims=:" %%i in ('findstr /n ".*" "address update.txt"') do (
set a=%%j
if "%%j"=="" (echo;) else (
echo;!a:000- woodlands drive 79=000- sembawang street 66!
)
)
pause

复制代码

qspringleaf · 发表于 2021-10-4 20:49:32

回复 2# idwma

感谢🙏，想再请教如果该文件 address update.txt的完整路径是c:\address name\address update.txt, 当字符串被替换完成后，如何实现自动保存在原路径下，并覆盖原文件。感激不尽。

idwma · 发表于 2021-10-4 21:08:09

@echo off
setlocal enabledelayedexpansion
set "f=c:\address name\address update.txt"
(for /f "tokens=1* delims=:" %%i in ('findstr /n ".*" "%f%"') do (
set a=%%j
if "%%j"=="" (echo;) else (
echo;!a:000- woodlands drive 79=000- sembawang street 66!
)
)>tmptmp
move /y tmptmp %f%
pause

复制代码

Batcher · 发表于 2021-10-4 21:10:21

回复 3# qspringleaf

@echo off
setlocal enabledelayedexpansion
cd /d "C:\address name"
(for /f "tokens=1* delims=:" %%i in ('findstr /n ".*" "address update.txt"') do (
set a=%%j
if "%%j"=="" (
echo;
) else (
echo;!a:000- woodlands drive 79=000- sembawang street 66!
)
))>"address update.tmp"
move /y "address update.tmp" "address update.txt"

复制代码

qspringleaf · 发表于 2021-10-5 20:18:58

回复 5# Batcher

感谢老师，试过了，成功！

		自动登录	找回密码
密码			注册

[新手上路]批处理新手入门导读	[视频教程]批处理基础视频教程	[视频教程]VBS基础视频教程	[批处理精品]批处理版照片整理器
[批处理精品]纯批处理备份&还原驱动	[批处理精品]CMD命令50条不能说的秘密	[在线下载]第三方命令行工具	[在线帮助]VBScript / JScript 在线参考

[文本处理] 请教bat批处理，文件名或其存放路径名含有空格，需替换字符串也带有空格