How to convert huge MS Vista glossary into Excel
Thread poster: Doron Greenspan MITI

Doron Greenspan MITI  Identity Verified
Israel
Local time: 20:05
Member (2005)
English to Hebrew
+ ...
Nov 13, 2007

One of my client provided me with a huge Excel file containing the new MS Vista glossary (Eng>Heb).
The thing is, it's way over 65536 lines long, so my Excel 2003 won't accept it, and only presents its first 65536 lines.

The MS error message suggests saving it as text file (which I did) and breaking it into 'edible' chunks.

Any idea on how I can do that efficiently with the text file?

Thanks, Doron


Direct link Reply with quote
 

Sabine Schlottky  Identity Verified
Germany
Local time: 19:05
Member (2005)
English to German
+ ...
Use a search program Nov 13, 2007

When I have to work with large Excel files like this, I usually don't open them, but search them using a search program such as "Search & Replace" or "InfoRapid". This is maybe not 100% satisfying, but as those programs always give you some context, I have considered them quite useful.

Direct link Reply with quote
 

Harry Bornemann  Identity Verified
Mexico
English to German
+ ...
File Splitter Nov 13, 2007

File Splitter is a freeware program which does not require installation and can be used to split files to multiple chunks as well as to merge multiple chunks into a single file.

www.filesplitter.org

I tried it with a huge .txt file and it worked fine, I just had to add the extension .txt to the chunks.

[Edited at 2007-11-13 20:59]


Direct link Reply with quote
 

Hynek Palatin  Identity Verified
Czech Republic
Local time: 19:05
English to Czech
+ ...
ApSIC Xbench Nov 14, 2007

You didn't specify the file format, but I suppose it's .csv. It's no use opening a huge MS glossary in Excel. You can use a general search program, as Sabine suggests, or even better a specialized tool, such as ApSIC Xbench. It allows you to search a glossary (or several glossaries) by selecting a word or phrase in your editor and pressing a hotkey. It shows fuzzy matches too and it can also automatically replace a term with the translation, also via a hotkey.

BTW, File Splitter will just chop the file into several smaller pieces regardless of the file structure (for copying to a removable drive with small capacity, for example) and that is not what you need.


Direct link Reply with quote
 

Wilmer Brouwer
Netherlands
Local time: 19:05
Member (2006)
English to Dutch
+ ...
Access Nov 14, 2007

I use Microsoft Access for files that are too big for Excel.

Direct link Reply with quote
 

Doron Greenspan MITI  Identity Verified
Israel
Local time: 20:05
Member (2005)
English to Hebrew
+ ...
TOPIC STARTER
Wow Nov 14, 2007

What a great collection of ideas!
Many thanks, Sabine, Harry, Hynek and Wilmer - I'll try them all to get it right for my elephant csv, starting with Access, which I already have.

Doron


Direct link Reply with quote
 

Riccardo Schiaffino  Identity Verified
United States
Local time: 11:05
Member (2003)
English to Italian
+ ...
XBench or S&R Nov 14, 2007

Either XBench (which is free) or Funduc's Search & Replace (which is shareware and only costs 40 dollars or so) are much better than using Excel to find information in the Microsoft glossaries: using Excel you only get a hit at a time, while XBench and S&R show all the results at the same time, in addition to which they permit very complex searches (e.g., find all the strings in which "save" is not followed in the same string by "file", and similar).

Direct link Reply with quote
 

Doron Greenspan MITI  Identity Verified
Israel
Local time: 20:05
Member (2005)
English to Hebrew
+ ...
TOPIC STARTER
Thanks, Riccardo Nov 16, 2007

I will get that tool - seems it's worth trying!

Doron


Direct link Reply with quote
 

Doron Greenspan MITI  Identity Verified
Israel
Local time: 20:05
Member (2005)
English to Hebrew
+ ...
TOPIC STARTER
XBench does the trick (well) Nov 23, 2007

Just a final note to say that I tried XBench, which has no problem dealing with that huge glossary, and it's working fine.

There's also great support from the creators, who helped me sort a problem with the display of Hebrew fonts.

Highly recommended!

Doron


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 »

How to convert huge MS Vista glossary into Excel

Advanced search






Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »



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