Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Tool to Search thousands of docx & xlsx files for a string of text

Posted on 2016-08-19
10
Medium Priority
?
433 Views
Last Modified: 2016-09-10
I recall in the older Win XP explorer, I could search in the contents of various files (.doc & .xls)
in a tree of folders for a particular string of text.

Can this still be done in Win 7 or any freeware tool to do this?

Win Explorer of Win 7 doesn't like it has this search function anymore.

At command prompt, if I use the   ' find/Ii  "string" *.docx  ', it won't locate a string which
I'm sure is present in the .docx files though I could locate it if it is  .rtf files
0
Comment
Question by:sunhux
9 Comments
 

Author Comment

by:sunhux
ID: 41763382
http://www.tech-recipes.com/rx/8808/windows-7-always-search-for-contents-inside-files/

Above link shows how to enable this but it did not elaborate on how to do the search:
I tried double click on a folder but there's no "search" function show
0
 
LVL 23

Assisted Solution

by:tailoreddigital
tailoreddigital earned 400 total points
ID: 41763396
I've used TextCrawler for at least 5 or 6 years to do that plus a few other features.

https://www.digitalvolcano.co.uk/textcrawler.html

They have a paid version and a free one.   I've only used the free one over the years.
0
 
LVL 3

Assisted Solution

by:Ganga Sagar
Ganga Sagar earned 360 total points
ID: 41763398
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 41763450
Why don't you just use the native Windows 7 search???  It should work just fine for what you are trying to do.  Search either from the start button's input box or from Windows Explorer in the upper right corner.

If, for some reason, your files aren't in the default My Documents folder you may need to add the folder to the search index.  To do this, just click the start button and type "search" then open the search options to adjust.
0
 

Author Comment

by:sunhux
ID: 41764347
> native Windows 7 search
Can you elaborate more on how to go about doing this?  As it's a corporate laptop,
just realized I may not be allowed to install freewares.

After entering "Search" at the "Search programs & files" field that pops up when I
click the Windows "Start" button, got the screen attached
W7search.jpg
0
 
LVL 25

Expert Comment

by:NVIT
ID: 41773346
@Sunhux

> ...link shows how to enable this but it did not elaborate on how to do the search:

After step 5 of that link. Hit OK to save the setting. From now on, you can search for contents inside files (like .docx, .zip)  in non-indexed locations

As the image below step 5 shows, and as Jeffrey mentioned in his post, pick at the upper right of the Windows Explorer window. Then, type your search term.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Kane - TechSoEasy earned 920 total points
ID: 41783287
> native Windows 7 search
Can you elaborate more on how to go about doing this?

I don't think we can be any clearer -- but here is a picture that may help:

Search Box
0
 
LVL 27

Assisted Solution

by:ProfessorJimJam
ProfessorJimJam earned 320 total points
ID: 41783637
i answered similar question in  here
https://www.experts-exchange.com/questions/28952558/Challenge-to-VBA-masters-VBA-to-find-and-replace-and-save-and-close-files.html#a41667193

which was accepted by user.

there is a free VBA add-in developed by Funduc Software guys.

it will do the job both for Excel and for Word, two seperate add-ins, it is also free and do not require any installation.  

it also creates a text file for tracking of the files changed.

make sure you do the backup before running this.

also there is a commercial software that does the job, it is easy to use, but not free.

0
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 41784780
@ProfessorJimJam

That question is not at all similar to this one.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is a real story and is one of my scariest tech experiences. Most users think that IT experts like us know how to fix all computer problems. However, if there is a time constraint and you MUST not fail the task or you will lose your job, a simple …
Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

876 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