Mobile menu

How to prepare MS csv glossaries for Multiterm Convert
Thread poster: OnlineArabic
OnlineArabic  Identity Verified
Local time: 04:24
Member (2007)
English to Arabic
+ ...
Sep 30, 2006

Dear Friends,

Thank you all in advance!

I have a previous version of MS csv glossaries (English>Arabic), which I want to prepare for Multiterm Convert. I just want to make a source and target column, but the problem is that in this version they combined the old columns Source Term, Translation, String Category, Platform, Product into one cell separated by two commas and quotes (,,"). here is an example

Output File,,"ملف الإخراج",,"TXT",,"Windows",".NET Framework 1.1"

I tried to use the Convert text to columns Wizard in Excel, but the result was not accurate because some source texts already contained commas, and thus was splitted into two different columns when I ran the wizard. I also noticed that the last part of the cells is separated by one comma and quotes (,".NET Framework 1.1").

I just want a source column and a target column and I will convert them using Multiterm Convert 7.0.1.320. Can you advise me on how to do this?

Best Regards,
Ahmed


Direct link Reply with quote
 
esperantisto  Identity Verified
Local time: 05:24
Member (2006)
English to Russian
+ ...
Use any text editor Oct 2, 2006

Open that file in any text editor that is capable of reading text in your encoding and searching/replacing text (a good one is UniRed: http://www.esperanto.mv.ru/UniRed/UTF8/index.html or jEdit http://www.jedit.org). Then call the search and replace dialog and put ,," into the search field and a regular expression for tab (usually \t) into the replace field (also switch regexps on). Replace all. Import your file with tabs as field separators and remove undesired columns.

[Редактировалось 2006-10-02 07:43]


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 prepare MS csv glossaries for Multiterm Convert

Advanced search


Translation news related to SDL Trados





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 »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »



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