How to replace a group of characters of a word in a text file using batch script?

Question

Edited **
I have a text file called sample.txt which keeps updating. It contains various pathnames:

C:/users/admin/abc
C:/users/admin/xyz
C:/users/admin/jkl
C:/users/admin/mno
...
...

I want to replace "admin" with "admin1" and save that file in sample1.txt
I tried to use this:

y = admin1  
FOR /F "tokens=* delims=/" %%x in (sample.txt) DO ^  
if %%x==admin (%%y > sample1.txt) else (%%x > sample1.txt)

My output should in sample1.txt:

C:/users/admin1/abc
C:/users/admin1/xyz
C:/users/admin1/jkl
C:/users/admin1/mno

Accept an answer in this question.

Squashman
– Squashman

2017-10-06 19:08:40 +00:00
Commented Oct 6, 2017 at 19:08 — Squashman
– Squashman, Commented Oct 6, 2017 at 19:08

Compo · Accepted Answer · 2017-10-20 18:09:43Z

2

Will this simple batch file do?

@(For /F "Delims=" %%A In ('Find /I "/admin/"^<"sample.txt"'
) Do @Set "_=%%A"&@Call Echo %%_:/admin/=/admin1/%%)>"sample1.txt"

Edit The following may be less susceptible to poison characters in sample.txt

@(For /F "Delims=" %%A In ('Find /I "/admin/"^<"sample.txt"'
) Do @Set "_=%%A"&Call Set/P "_=%%_:/admin/=/admin1/%%"<Nul&Echo()>"sample1.txt"

edited Oct 20, 2017 at 18:09

answered Oct 3, 2017 at 16:07

Compo

39k5 gold badges32 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vaibhav Borkar Over a year ago

Hey I think it works perfectly, but i found a glitch when i try to put the file name as "C:/users/admin/a&c" ..it does not work for this. Can you tell me how i can correct

Compo Over a year ago

TBF, my suggestion is to never have any directory or file named using characters which could cause issues, and that is one of those! You could escape the ampersand, &, with a caret, ^, but my recommendation is that all of the paths within sample.txt should be doublequoted, "C:/users/admin/a&c". I have edited my post with an awkward looking workaround which may however suit your purpose better.

Mike Tung · Accepted Answer · 2017-10-03 16:49:31Z

1

you can do the following for bash

#!/bin/bash
set -e

declare -a myarray
readarray myarray < file_pathname # Include newline.
readarray -t myarray < file_pathname # Exclude newline.
new_string=admin1

for s in ${myarray[@]}; do
  echo $s;
  echo ${s/admin/$new_string}
done

edited Oct 3, 2017 at 16:49

answered Oct 3, 2017 at 15:51

Mike Tung

4,8411 gold badge19 silver badges25 bronze badges

11 Comments

Vaibhav Borkar Over a year ago

the text file keeps updating so, everytime the end value "/abc" ,"/xyz" , etc will keep updating. So i will not be able to use that

Mike Tung Over a year ago

I don't understand what you mean. It does what you want replaces admin with admin1

Vaibhav Borkar Over a year ago

yes it will work. but my text file keeps updating and has many such pathnames inside the text file.

Vaibhav Borkar Over a year ago

My text file can be: C:/users/admin/abc C:/users/admin/xyz C:/users/admin/jkl C:/users/admin/mno C:/users/admin/asd C:/users/admin/asdasd C:/users/admin/jasdasdkl C:/users/admin/asasd

Mike Tung Over a year ago

as long as it's separated by newlines it doesn't matter,

|

Collectives™ on Stack Overflow

How to replace a group of characters of a word in a text file using batch script?

2 Answers 2

2 Comments

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related