[文本处理] 批处理怎样替换指定内容并设置每个小时运行替换一次？

xiuan

指定内容替换，最后能设置每个小时运行替换一次（第几位可以用逗号识别）

源txt
20210816230000,3439-1000,1,2,3,4,5,0,1,2,0,0,0,0,0,0,0,1,1,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,
20210816230000,3439-3,2,49,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,
20210816230000,7686-19,2,3,1,0,0,1,2,2,0,5,5,17,17,18,34,41,50,46,40,45,30,33,44,
20210816230000,7686-100001,0,14,9,5,6,10,27,43,26,38,54,74,22,10,9,4,13,24,9,6,11,4,5,10,

修改要求：（第几位可以用逗号识别）
3439-1000/7686-19后面的
第1位改成2
第2位改成4
第3位改成5
第4位改成7
第5位改成9
第6位改成10
第7位改成10

修改后txt
20210816230000,3439-1000,2,4,5,7,9,10,10,2,0,0,0,0,0,0,0,1,1,1,0,0,0,0,0,0,0,
20210816230000,3439-3,2,49,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,1,0,0,0,0,0,0,
20210816230000,7686-19,2,4,5,7,9,10,10,2,0,5,5,17,17,18,34,41,50,46,40,45,30,33,44,
20210816230000,7686-10001,0,14,9,5,6,10,27,43,26,38,54,74,22,10,9,4,13,24,9,6,11,4,5,10,

idwma

@echo off
:loop
(for /f "tokens=1-10* delims=,-" %%a in (111.txt) do (
if "%%b-%%c"=="3439-1000" (
echo;%%a,%%b-%%c,2,4,5,7,9,10,10,%%k
) else if "%%b-%%c"=="7686-19" (
echo;%%a,%%b-%%c,2,4,5,7,9,10,10,%%k
) else (
echo;%%a,%%b-%%c,%%d,%%e,%%f,%%g,%%h,%%i,%%j,%%k
)
))>222.txt
move /y 222.txt 111.txt
ping -n 3600 127.1>nul
goto :loop
复制代码

Batcher

回复 2# idwma


放在任务计划里面执行比较好。ping + loop 太浪费系统资源

@echo off
(for /f "tokens=1-9* delims=," %%a in ('type "D:\Test\1.txt"') do (
    if "%%b" equ "3439-1000" (
        echo %%a,%%b,2,4,5,7,9,10,10,%%j
    ) else if "%%b" equ "7686-19" (
        echo %%a,%%b,2,4,5,7,9,10,10,%%j
    ) else (
        echo %%a,%%b,%%c,%%d,%%e,%%f,%%g,%%h,%%i,%%j
    )
))>"D:\Test\2.txt"
复制代码

xiuan

回复 2# idwma


如果是多个txt且带RS文件名  比如RS2021082201111.txt  RS2021082202112.txt  RS2021082203111.txt   原来的TXT移动到其他文件夹或者删除

idwma

回复 4# xiuan

@echo off
for /f "delims=" %%i in ('dir/b/s "D:\Test\rs*.txt"') do (
(for /f "tokens=1-9* delims=," %%a in ('type "%%i"') do (
    if "%%b" equ "3439-1000" (
        echo %%a,%%b,2,4,5,7,9,10,10,%%j
    ) else if "%%b" equ "7686-19" (
        echo %%a,%%b,2,4,5,7,9,10,10,%%j
    ) else (
        echo %%a,%%b,%%c,%%d,%%e,%%f,%%g,%%h,%%i,%%j
    )
))>"%%i.txt"
del %%i
)
复制代码

xiuan

回复 5# idwma


    功能没问题，但是新的文件名称多了.txt

Batcher

回复 6# xiuan


5楼第12行改成这样试试：
move /y "%%i.txt" "%%i"