Vista - Re: Wildcard Search Modification to Script

At this point I have not considered any other options than those mentioned.
Mainly because I like the idea of being presented with an input box over
typing the variable for %1 when running the batch file.

In the perferct world, I'd get the company I work for to higher a programmer
and have them develop a VB application that would run my query and provide an
option to open the file in Excel.

Utopia is a long way off. . . .

"Pegasus (MVP)" wrote:

You can have your cake and eat it:
- Prompt the user for a folder name by using an input box.
- Pass the folder name to your own batch file.
- Pick up the output from the batch file and digest it with your script.

What does your batch file look like?


"Hal" <Hal@xxxxxx> wrote in message
news:5A711CC7-71EE-4CCC-BCAF-E7D62698C1C2@xxxxxx

This is the contents of my batch file.

@echo off
REM ***********************
REM * Locate engine test log files
REM * Must have Mapped Drives to Test Stands
REM * Must input a unit number at time batch file is run
REM ***********************
REM * Useful Info for the file search
REM ***********************
echo Mapped Drive Reference: >> %TEMP%\TestFiles.txt
echo. >> %TEMP%\TestFiles.txt
echo I: = 91, J: = 92, N: = 93, O: = 94, U: = 95 S4k, V: = 95 S2k, W: = 96echo If a drive letter is missing, check the mapped drive >>
%TEMP%\TestFiles.txt
echo connections via Windows Explorer >> %TEMP%\TestFiles.txt
echo _________________________________________________________ >>
%TEMP%\TestFiles.txt
echo. >> %TEMP%\TestFiles.txt
REM ***********************
REM * Search the mapped official data directorys
REM ***********************
DIR /O-D I:\data\official\%1*.* >> %TEMP%\%1.txt
DIR /O-D J:\data\official\%1*.* >> %TEMP%\%1.txt
DIR /O-D N:\data\official\%1*.* >> %TEMP%\%1.txt
DIR /O-D O:\data\official\%1*.* >> %TEMP%\%1.txt
DIR /O-D U:\data\official\%1*.* >> %TEMP%\%1.txt
DIR /O-D V:\data\official\%1*.* >> %TEMP%\%1.txt
DIR /O-D W:\data\official\%1*.* >> %TEMP%\%1.txt
REM ***********************
REM * Get the important part of the search
REM ***********************
FINDSTR "Directory %1" %TEMP%\%1.txt >>%TEMP%\TestFiles.txt
REM ***********************
REM * Display the search results
REM ***********************
notepad %TEMP%\TestFiles.txt
REM notepad %TEMP%\%1.txt
REM ***********************
REM * Do the clean up
REM ***********************
DEL %TEMP%\%1.txt
DEL %TEMP%\TestFiles.txt
@echo on


"Pegasus (MVP)" wrote:
<snip>