Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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


  #6   Report Post  
Posted to microsoft.public.excel.programming
Hal Hal is offline
external usenet poster
 
Posts: 36
Default 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?

  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW DO I FIND A FILE WHEN SHORTCUT DOES NOT WORK pat Excel Discussion (Misc queries) 1 August 2nd 07 06:16 PM
Would Like to Automate Batch File Creation and Text FIle Import socrtwo Excel Discussion (Misc queries) 2 August 18th 06 03:54 PM
How can I work in excel 2000 with the find window open? meads991 Excel Worksheet Functions 1 September 2nd 05 06:23 AM
Find File doesn't work properly Peter[_20_] Excel Programming 4 April 21st 04 03:38 PM
Cant get my code work. Find file or create it Poseilus Excel Programming 1 October 12th 03 03:42 PM


All times are GMT +1. The time now is 03:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"