Script to edit multiple filesSolved/Closed

Question

Hello,

How do I go about writing a script that will edit multiple text files? This is to be performed on 4 different servers that are Dell 1850's running Win Server 2003. Files extensions such as *.htm, *.ini, and *.xml. Actions would be mostly find/replace text strings and adding/removing comments. Some I'm sure there is a means to accomplish this and I am hoping this is the right place to ask.

Holler if more info is needed.

Thanks in advance
Fred

syeddilawer · Accepted Answer

Hi Freondude,

If you are still looking for an answer, then try this:

1.Open Notepad,  Copy and paste the below script :

@echo off
REM — Prepare the Command Processor –
SETLOCAL ENABLEEXTENSIONS
SETLOCAL DISABLEDELAYEDEXPANSION

::BatchSubstitude – parses a File line by line and replaces a substring”
::syntax: BatchSubstitude.bat OldStr NewStr File
::          OldStr [in] – string to be replaced
::          NewStr [in] – string to replace with
::          File   [in] – file to be parsed
if “%*”==”" findstr “^::” “%~f0&#8243;&GOTO:EOF
for /f “tokens=1,* delims=]” %%A in (’”type %3|find /n /v “”"‘) do (
    set “line=%%B”
    if defined line (
        call set “line=echo.%%line:%~1=%~2%%”
        for /f “delims=” %%X in (’”echo.”%%line%%”"‘) do %%~X
    ) ELSE echo.
)

2. Save the file as “xyz.bat”

The above script will parses a file line by line and will replaces a desired substring.

3. Open cmd prompt >> type the following command:

c:\xyz.bat “text-to-replace” text-to-replace-with c:\FileToEdit.txt > c:\Edited_file.txt

For more info, visit https://winitpro.wordpress.com/2009/07/31/batchscript/

Hope this helps :)

alvin · Answer

to change files in folders and subs just use something like this:

C:\Users\jo\Pictures	o-upload*.*ren *.JPG *.jpg

SenHu · Answer

Hi Newboy:

Here is the script for you. I have added comments (#) so it will be easy for you to understand what it does.


# Script Microsoft2Yahoo.txt
# .html files are in folder C:/abc. Collect a list of them.
var str list ; lf -n "*.html" "C:/abc" > $list
# Process files one by one.
while ( $list <> "")
do
    # Get the next file.
    var str file ; lex "1" $list > $file
    # Read file contents into a string variable.
    var str content ; cat $file > $content
    # Keep replacing "www.micosoft.com" with "www.yahoo.com" until there are
    # no more instances left of "www.micosoft.com".
    while ( { sen -c "^www.micosoft.com^" $content } > 0 )
        sal "^www.micosoft.com^" "www.yahoo.com" $content > null
    # All instances are replaced. Write file back.
    echo $content > { echo $file }
done



Save the script as C:/Scripts/Microsoft2Yahoo.txt, start biterscripting ( http://www.biterscripting.com ) , enter the following command.


script "C:/Scripts/Microsoft2Yahoo.txt"


We are using the file-directory-loop to loop thru files, the sen (string enumerator) command to count instances of "www.microsoft.com" in a string, and the sal (string alterer) command to replace "www.microsoft.com" with "www.yahoo.com". Help on all of these is available at that web site. (It might help to learn a bit of biterscripting if you plan on automating things of this nature in the future. They have some good tutorials posted on their site.)


Sen

SenHu · Answer

Thank you for pointing out the misspelled variable in the script. The variable $content was misspelled as $coontent. Here is the corrected script.


# Get a list of .html files. 
var str list ; lf -n "*.html" > $list 
# File loop. 
while ($list <> "") 
do 
# Read in the next file. 
var str file ; lex "1" $list > $file 
var str content ; cat $file > $content 
# Replace "ABC" to "XYZ". 
sal "^ABC^" "XYZ" $content > null 
# Write file back. 
echo $content > { echo $file } 
done


Sen

eilz · Answer

anyone know if a Carriage Return is possible after the change has been made, so:

(file 1)

hi this is cool

-------------BECOMES ------------------ 

hello
this is cool

("hi" and "hello" being the replacement for "www.micosoft.com" and "www.yahoo.com" in the script that is.)

Thanks, appreciate help.

Eilz

New2This · Answer

The above Error 602: has be resolved.... thanks

Script to edit multiple files

6 responses

Similar discussions

Subscribe To Our Newsletter!