ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Why would FIND not work as a batch file in a DOS window? (https://www.excelbanter.com/excel-programming/340443-why-would-find-not-work-batch-file-dos-window.html)

Denny

Why would FIND not work as a batch file in a DOS window?
 
When I type out FIND....it find the word, but if I put it in a batch file, it
doesn't come up with an answer. Is there any difference between regular DOS
and the window of DOS in that regard?

Tom Ogilvy

Why would FIND not work as a batch file in a DOS window?
 
There shouldn't be. Perhaps the directory being reviewed is different in
each instance.

--
Regards,
Tom Ogilvy

"denny" wrote in message
...
When I type out FIND....it find the word, but if I put it in a batch file,

it
doesn't come up with an answer. Is there any difference between regular

DOS
and the window of DOS in that regard?




Dave Peterson

Why would FIND not work as a batch file in a DOS window?
 
Not that I'm aware, but if you're using the old DOS command to search through
excel files, you probably won't get what you expected.

On the other hand, if you save your data as a text file (*.csv), it might work
the way you want.

denny wrote:

When I type out FIND....it find the word, but if I put it in a batch file, it
doesn't come up with an answer. Is there any difference between regular DOS
and the window of DOS in that regard?


--

Dave Peterson

Hal

Why would FIND not work as a batch file in a DOS window?
 
Try findstr for your search. Of course findstr /? at the prompt will give you
all the how to use info.

Hal

"denny" wrote:

When I type out FIND....it find the word, but if I put it in a batch file, it
doesn't come up with an answer. Is there any difference between regular DOS
and the window of DOS in that regard?


Denny

Why would FIND not work as a batch file in a DOS window?
 
This much works for me
find "%1" /I c:\mydocu~1\findtest.txt c:\mydocu~1\found2.txt
....but when I try adding "%2" the end ( c:\mydocu~1\found2.txt) seems to
block it



Denny

Why would FIND not work as a batch file in a DOS window?
 
I finally discovered after I succeeded in closing the txt file by saving it
as an .xls file...I noticed that it was cutting of part of my text (in my big
cells)...so FIND wouldn't find it. Then I tried saving it as .cvs and the
whole text was preserved and found. It still is not working when I try to
search 2 strings at once, but I will try a little more. I just wanted to let
you know how this answer led me to another step of success.

"Dave Peterson" wrote:

Not that I'm aware, but if you're using the old DOS command to search through
excel files, you probably won't get what you expected.

On the other hand, if you save your data as a text file (*.csv), it might work
the way you want.

denny wrote:

When I type out FIND....it find the word, but if I put it in a batch file, it
doesn't come up with an answer. Is there any difference between regular DOS
and the window of DOS in that regard?


--

Dave Peterson


Dave Peterson

Why would FIND not work as a batch file in a DOS window?
 
I've never saved a text file as .xls, so I don't have a guess.

denny wrote:

I finally discovered after I succeeded in closing the txt file by saving it
as an .xls file...I noticed that it was cutting of part of my text (in my big
cells)...so FIND wouldn't find it. Then I tried saving it as .cvs and the
whole text was preserved and found. It still is not working when I try to
search 2 strings at once, but I will try a little more. I just wanted to let
you know how this answer led me to another step of success.

"Dave Peterson" wrote:

Not that I'm aware, but if you're using the old DOS command to search through
excel files, you probably won't get what you expected.

On the other hand, if you save your data as a text file (*.csv), it might work
the way you want.

denny wrote:

When I type out FIND....it find the word, but if I put it in a batch file, it
doesn't come up with an answer. Is there any difference between regular DOS
and the window of DOS in that regard?


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com