This course will introduce you to C++ 11 and teach you about syntax fundamentals.
How can I search through a file to check to see if there are two lines that start with the same characters?
At a command line in Windows, I want to search through a specific file and if it finds 2 instances of a line beginning with the same alphacharacters, then it needs to run a a specific vbs script.
For instance, in file located at c:\info\input.txt
Searching through the file,
If there are two lines in succession which start with DTM*, then it needs to run a cscript of 2.vbs, however if it finds
only 1 line starting with DTM* on it's own, then it needs to run 1.vbs.
What command line commands can I use to accomplish this?
Thanks.
For instance, in file located at c:\info\input.txt
Searching through the file,
If there are two lines in succession which start with DTM*, then it needs to run a cscript of 2.vbs, however if it finds
only 1 line starting with DTM* on it's own, then it needs to run 1.vbs.
What command line commands can I use to accomplish this?
Thanks.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
This should do it; it's in test mode and will only display the csript commands; adjust lines 15 and 17 to your likings once you tested it successfully:
@echo off
setlocal enabledelayedexpansion
set InputFile=c:\info\input.txt
set FoundDouble=FALSE
set /a TestIndex = -1
for /f "tokens=1* delims=:" %%a in ('type "%InputFile%" ^| findstr.exe /n /r /i /c:"^DTM"') do (
echo Line %%a: %%b
if !TestIndex!==%%a (
set FoundDouble=TRUE
) else (
set /a TestIndex = %%a + 1
)
)
if %FoundDouble%==FALSE (
ECHO cscript.exe /nologo "1.vbs"
) else (
ECHO cscript.exe /nologo "2.vbs"
)
Thank you. It seems to search through the file well, however how can identify the path where 1.vbs and 2.vbs resides? Currently I have both vbs files in the same folder however the vbs file is not executing.
Do you only want to consider it a double if it is on the very next line, or could it be separated from the first by other lines?
~bp
~bp
Did you remove the ECHO at the beginning of the line?
And do you mean in the same folder as the batch script? Just use "%~dp0", which will expand to the batch script's current Drive and Path, with a trailing backslash:
And do you mean in the same folder as the batch script? Just use "%~dp0", which will expand to the batch script's current Drive and Path, with a trailing backslash:
@echo off
setlocal enabledelayedexpansion
set InputFile=c:\info\input.txt
set FoundDouble=FALSE
set /a TestIndex = -1
for /f "tokens=1* delims=:" %%a in ('type "%InputFile%" ^| findstr.exe /n /r /i /c:"^DTM"') do (
echo Line %%a: %%b
if !TestIndex!==%%a (
set FoundDouble=TRUE
) else (
set /a TestIndex = %%a + 1
)
)
if %FoundDouble%==FALSE (
cscript.exe /nologo "%~dp01.vbs"
) else (
cscript.exe /nologo "%~dp02.vbs"
)
Premium Content
You need an Expert Office subscription to comment.Start Free Trial