How to prepare MS csv glossaries for Multiterm Convert
Thread poster: OnlineArabic
OnlineArabic  Identity Verified
Local time: 02:06
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: 03:06
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







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 »
PDF Translation - the Easy Way
TransPDF converts your PDFs to XLIFF ready for professional translation.

TransPDF converts your PDFs to XLIFF ready for professional translation. It also puts your translations back into the PDF to make new PDFs. Quicker and more accurate than hand-editing PDF. Includes free use of Infix PDF Editor with your translated PDFs.

More info »



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