Text search tool for Excel files?
Thread poster: Jan Sundström

Jan Sundström  Identity Verified
Sweden
Local time: 08:26
English to Swedish
+ ...
Apr 22, 2008

Hi all,

I want to hear your suggestions for a third-party tool that can do text searches in multiple Excel files.

My typical usage is to search for software strings in glossary files, that contain a lot of code and terms more or less jumbled...

I know, Windows has a search funtion in Explorer that does this, but I'm looking for something more versatile:
- faster
- can search in multiple folders, not just one folder structure
- boolean operators
- other search parameters, limit search by column, limit by start-end character etc.

Is there such a search tool? What do you use?

/J


 

Attila Piróth  Identity Verified
France
Local time: 08:26
Member
English to Hungarian
+ ...
google desktop Apr 22, 2008

You can set the file type in Preferences.
You cannot directly restrict the search to certain columns but that may not be so important.
HTH
Attila


 

Buck
Netherlands
Local time: 08:26
Dutch to English
Wondered about that myself Apr 22, 2008

I still do not understand why people insist on using Excel for text. What's wrong with tables in Word (or your word processor of choice)?

 

Antoní­n Otáhal
Local time: 08:26
Member (2005)
English to Czech
+ ...
one option is sleuthhound Apr 22, 2008

http://www.isleuthhound.com/

Or you can export as csv and use UltraEdit http://www.ultraedit.com/

Or export to Word and use http://www.searchandreplace.com/search_replace.htm

HTH

Antonin


 

Sylvain Leray  Identity Verified
Local time: 08:26
Member (2003)
German to French
ApSIC XBench Apr 23, 2008

is perfect for this kind of files once you have saved them as .csv files (like Microsoft Glossaries). It displays the results as columns so you can instantly check both source and target and other fields. A very useful tool, not only for glossaries !

Sylvain


 

Jan Sundström  Identity Verified
Sweden
Local time: 08:26
English to Swedish
+ ...
TOPIC STARTER
Thanks! Apr 24, 2008

Buck wrote:

I still do not understand why people insist on using Excel for text. What's wrong with tables in Word (or your word processor of choice)?


Thanks a lot everybody for the useful suggestions.

Just a clarification for Buck: we're not talking about "people" insisting anything here.

Like Sylvain suggested, these are huge software glossary files, 10-15 columns wide, and thousands of lines long. The glossary terms have been dumped in cells automatically by the client's tool.

Think Microsoft, Apple, IBM etc... You can't really dial a number, call up the client and tell them to use adapt their entire globalization workflow and use Word instead, just because one poor translator prefers it!icon_smile.gif

[Edited at 2008-04-24 12:20]


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Text search tool for Excel files?

Advanced search






PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search