Solved

Batch File: String manipulation

Posted on 2010-08-19
21
1,163 Views
Last Modified: 2012-05-10
Hi there,

I need to replace a the word "SAISON" from a text file to the word "PERIOD+".

SCRIPT TO FIX:

@echo off
setlocal enabledelayedexpansion

FOR "delims=" %%A in (%File_LOG_Mirror%) do (
      ECHO !%%A:SAISON=PERIOD^+!>>%File_LOG_Mirror_TEMP%
      DEL %File_LOG_Mirror%
      REN %File_LOG_Mirror_TEMP% %File_LOG_Mirror%
)

exit


Thanks,
Rene
0
Comment
Question by:ReneGe
  • 6
  • 5
  • 4
  • +2
21 Comments
 
LVL 16

Assisted Solution

by:Bryan Butler
Bryan Butler earned 20 total points
Comment Utility
Can you use WSH or powershell?  Or any other language?
0
 
LVL 42

Expert Comment

by:sedgwick
Comment Utility
u mean the file name should be manipulated or the file content?
0
 
LVL 10

Author Comment

by:ReneGe
Comment Utility
Content. Thanks
0
 
LVL 10

Author Comment

by:ReneGe
Comment Utility
==> NO. just batch file.

Thanks
0
 
LVL 10

Author Comment

by:ReneGe
Comment Utility
==> developedtester

NO. just batch file.

Thanks
0
 
LVL 42

Assisted Solution

by:sedgwick
sedgwick earned 30 total points
Comment Utility
here's a vb script which does that.replace TEXT_FILE with the file path you wish to manipulate.
const TEXT_FILE = "c:\temp\1.txt"

const FIND_STRING = "SAISON"

const REPLACE_STRING = "PERIOD+"



set objFSO = createobject("scripting.filesystemobject")

set objFile = objFSO.OpenTextFile(TEXT_FILE, 1)

fileContent = objFile.ReadAll

objFile.Close



set objFile = objFSO.OpenTextFile(TEXT_FILE, 2)

objFile.Write Replace(fileContent, FIND_STRING, REPLACE_STRING)

objFile.Close

Open in new window

0
 
LVL 42

Expert Comment

by:sedgwick
Comment Utility
for batch file solution check http://www.dostips.com/?t=Batch.FindAndReplace
0
 
LVL 51

Expert Comment

by:Bill Prew
Comment Utility
Looks like you are getting some good help on a scripting approach.  But an alternative is to use a small general purpose search and replace type utility, like the one mentioned in this therad.  There are a few of these around.

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/MS_DOS/Q_23185721.html

~bp
0
 
LVL 51

Expert Comment

by:Bill Prew
Comment Utility
If you know there are no funny characters, or blank lines in the file, then this may get the job done:

@echo off
setlocal enabledelayedexpansion

FOR "delims=" %%A in (%File_LOG_Mirror%) do (
      set Line=%%A
      ECHO !Line:SAISON=PERIOD^+!>>"%File_LOG_Mirror%._temp"
      DEL "%File_LOG_Mirror%"
      REN "%File_LOG_Mirror%._temp" "%File_LOG_Mirror%"
)

exit

~bp
0
 
LVL 16

Expert Comment

by:t0t0
Comment Utility
it's all very higgledy-piggledy...

firstly, as imaginative as it is, you can't do !%%a:abc=xyz!. I note we'd still have to rely on delayed expansion if it were possible. For that reason, %%a needs to be assigned to a variable first. Like this:

   set var=%%a
   echo !var:abc=xyz!

prew, if that works I'll take my hat off to you. Obviously, blank lines are not preserved.

As for the renaming thing... how about something like this:

BTW, AFAIK, you can't use DELIMS without 'FOR /F'.

Furthermore, because there are no double-quotes around %File_LOG_Mirror% in the FOR statement, I can only assume it contains no spaces. That being the case, the DEL and REN commands don't require them either.

However, to bo on the safe side, I would prefer to use USEBACKQ and  double-quotes (See next comment).



@echo off
setlocal enabledelayedexpansion

for /f "delims=" %%a in (%File_LOG_Mirror%) do (
      set line=%%a
      echo !line:SAISON=PERIOD^+!>>%File_LOG_Mirror%.tmp
)

move /y %File_LOG_Mirror%.tmp %File_LOG_Mirror%
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 16

Assisted Solution

by:t0t0
t0t0 earned 200 total points
Comment Utility
Uses USEBACKQ


@echo off
setlocal enabledelayedexpansion

for /f "usebackq delims=" %%a in ("%File_LOG_Mirror%") do (
      set line=%%a
      echo !line:SAISON=PERIOD^+!>>"%File_LOG_Mirror%.tmp"
)

move /y "%File_LOG_Mirror%.tmp" "%File_LOG_Mirror%"
0
 
LVL 51

Accepted Solution

by:
Bill Prew earned 250 total points
Comment Utility
Ah yes, that pesky bracket was in the wrong place!  Just to be clear it should look like this.

@echo off
setlocal enabledelayedexpansion

set File_LOG_Mirror=EE26415780.txt

FOR /F "usebackq delims=" %%A in ("%File_LOG_Mirror%") do (
    set Line=%%A
    ECHO !Line:SAISON=PERIOD^+!>>"%File_LOG_Mirror%._temp"
)
DEL "%File_LOG_Mirror%"
REN "%File_LOG_Mirror%._temp" "%File_LOG_Mirror%"

exit /b

~bp
0
 
LVL 16

Expert Comment

by:t0t0
Comment Utility
Come clean with me bill.... you were inspired by my previous comment! I like that. Ha ha ha...
0
 
LVL 16

Expert Comment

by:t0t0
Comment Utility
Just pulling your leg prew...
0
 
LVL 51

Expert Comment

by:Bill Prew
Comment Utility
It's all good.

~bp
0
 
LVL 16

Expert Comment

by:t0t0
Comment Utility
:)
0
 
LVL 10

Author Comment

by:ReneGe
Comment Utility
*** TO ALL OF YOU GUYS ***
*I first wish to tell you that I am more than impressed.
*Not only you were extremly proactive, but you worked together with a touch of magic.
********************************

The following last script from billprew (that was inspired by the previous comment of the leg puller t0t0...;-)worked without a glitch.

Thanks to you all. You are my heros!!

I just wished I could give more than 500 pts...

Cheers,
Rene
0
 
LVL 16

Expert Comment

by:t0t0
Comment Utility
Pleasing feedback.

Pity I missed the definition of %File_LOG_Mirror% - I genuinely thought this was defined elsewhere.

Not to worry though. We got there in the end. It's great to be credited. Thank you.

The challenge far outweighs the points.
0
 
LVL 51

Expert Comment

by:Bill Prew
Comment Utility
Thanks Rene.

~bp
0
 
LVL 16

Expert Comment

by:Bryan Butler
Comment Utility
Very kind Rene.  I wish you could give more points too!  lol  Glad we could help, or should I say they ;
Cheers,
dt
0
 
LVL 42

Expert Comment

by:sedgwick
Comment Utility
10x man
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now