Exporting source and target segments into separate files Thread poster: Raphael Corrêa
|
Hello there,
I've already searched this forum and the Internet and could not find anything related. Essentially what I need is to extract the segments (both source and translated segments) from my TM (which is huge, 100 MB+) into separated files, one containing each segment in the original language and the other the translated sentences. Although it seems an easy task, I couldn't find any software able to do it, only for the reverse function (aggregating two bilingual files into an assembl... See more Hello there,
I've already searched this forum and the Internet and could not find anything related. Essentially what I need is to extract the segments (both source and translated segments) from my TM (which is huge, 100 MB+) into separated files, one containing each segment in the original language and the other the translated sentences. Although it seems an easy task, I couldn't find any software able to do it, only for the reverse function (aggregating two bilingual files into an assembled TM).
I appreciate a lot any help!
Regards
Raphael (From Brazil) ▲ Collapse | | | | | What file format? | May 30, 2011 |
What tool are you using?
In Wordfast you simply load the TM (txt) into Excel (tab delimited) and select first the source column (file 1) and then the target column (file 2).
For other tools you could export into tmx and use a tool like Olifant to generate a Wordfast TM. Then back to step one above. | | | |
- export into a tab-delimited TXT file,
- open in Excel,
- delete unnecessary column.
(look here ) | | | | Raphael Corrêa Local time: 20:52 English to Portuguese + ... TOPIC STARTER
Man, that works perfectly!!! thank you so much!!
Raphael | | |
|
|
|
| Details, details | May 30, 2011 |
You didn't mention what tool you're using or what format the TM is in.
If your tool can export to tab delimited txt, then the txt->Excel route may be a possibility. However, Excel may corrupt some segments (if they contain numbers only, or start with = or - etc.). Also, if the size is very large, Excel might not be a feasible option.
In that case, you'd need to use something more powerful, such as perl. E.g.
... See moreYou didn't mention what tool you're using or what format the TM is in.
If your tool can export to tab delimited txt, then the txt->Excel route may be a possibility. However, Excel may corrupt some segments (if they contain numbers only, or start with = or - etc.). Also, if the size is very large, Excel might not be a feasible option.
In that case, you'd need to use something more powerful, such as perl. E.g.
Code:
|
perl -p -e "s/^([^\t]*).*$/" < infile.txt > outfile1.txt
|
|
and
Code:
|
perl -p -e "s/^[^\t]*\t([^\t]*).*$/" < infile.txt > outfile2.txt
|
|
If you can't get a tab delimited export from your CAT, you could use a TMX and convert it to tab delimited using Xbench or the tool in the grab bag here. ▲ Collapse | | |
Heinrich Pesch wrote:
...
In Wordfast you simply load the TM (txt) into Excel (tab delimited) and select first the source column (file 1) and then the target column (file 2).
For other tools you could export into tmx and use a tool like Olifant to generate a Wordfast TM. Then back to step one above.
In MemoQ, you can export to the two column format and then delete the target colum to obtain the source and the source column to obtain the target. | | | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » Exporting source and target segments into separate files | Trados Business Manager Lite | Create customer quotes and invoices from within Trados Studio
Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.
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 » |
|
| | | | X Sign in to your ProZ.com account... | | | | |
|
You can request verification for native languages by completing a simple application that takes only a couple of minutes.
Review native language verification applications submitted by your peers. Reviewing applications can be fun and only takes a few minutes.
View applications
|