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

Jan Sundström  Identity Verified
Sweden
Local time: 01:27
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


Direct link Reply with quote
 

Attila Piróth  Identity Verified
France
Local time: 01:27
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


Direct link Reply with quote
 

Buck
Netherlands
Local time: 01:27
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)?

Direct link Reply with quote
 

Antoní­n Otáhal
Local time: 01:27
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


Direct link Reply with quote
 

Sylvain Leray  Identity Verified
Local time: 01:27
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


Direct link Reply with quote
 

Jan Sundström  Identity Verified
Sweden
Local time: 01:27
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!

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


Direct link Reply with quote
 


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






TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »



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