Pages in topic: [1 2] > |
How best to handle a bilingual Excel file? Thread poster: Ali Alawadi
|
Ali Alawadi Türkiye Member (2006) English to Arabic + ...
Dear all, I have a bilingual Excel file in which the target text is above the source text. Both texts are in the same column. So, the the text looks like the following: Target Source Target source Target Source There are around 3000 rows this way. The client wants me to review/validate the target text. What is the best way to handle this task with memoQ? Many thanks in advance! | | |
Make a copy of the file. Delete the source columns. Translate in MemoQ and output to Excel. Copy the translated columns over to the original. That's what I'd do. Interested to hear if anyone has a different method. | | |
Ali Alawadi Türkiye Member (2006) English to Arabic + ... TOPIC STARTER Both source and target in same column | Feb 18 |
Both source and target are in the same column (but on alternate rows) like this: Source Target Source Target down to the end of file. There are 3000 rows. | | |
Dan Lucas United Kingdom Local time: 17:17 Member (2014) Japanese to English Why use a CAT tool at all? | Feb 18 |
I mean, if it's just review, why not check it in Excel and make a note of the cells that have issues? Dan | |
|
|
Ali Alawadi Türkiye Member (2006) English to Arabic + ... TOPIC STARTER For consistency reasons | Feb 18 |
Dan Lucas wrote: I mean, if it's just review, why not check it in Excel and make a note of the cells that have issues? Dan The file has +3000 rows. It's not easy to keep consistency. | | |
|
Ali Alawadi Türkiye Member (2006) English to Arabic + ... TOPIC STARTER
Many thanks, Thomas! I'm testing it. | | |
Stepan Konev Russian Federation Local time: 19:17 English to Russian
1. Import your file as a regular Excel file. 2. Open the file for translation, select all segments (Ctrl+Shift+A) and lock them (Ctrl+L, then OK). 3. Navigate to the Preparation tab and click Lock/Unlock Segments. 4. Select 'Unlock' for the Action option. 5. Select 'Rows in a different language' for the Segments to lock option. 6. Set the Minimum segment length (words... See more 1. Import your file as a regular Excel file. 2. Open the file for translation, select all segments (Ctrl+Shift+A) and lock them (Ctrl+L, then OK). 3. Navigate to the Preparation tab and click Lock/Unlock Segments. 4. Select 'Unlock' for the Action option. 5. Select 'Rows in a different language' for the Segments to lock option. 6. Set the Minimum segment length (words) to 1 and click OK. ![](https://i.ibb.co/xmwR6hc/2024-02-19-015823.jpg) *You may need to create and attach a "mock" TM because you would store monolingual segments in a bilingual TM as you go with editing.
[Edited at 2024-02-19 00:15 GMT] ▲ Collapse | |
|
|
...by naming the first cell of the second column L and the second R, copy both cells, mark the rest of the second column, paste the both cells entirely into it and then filter the entire file by the second column. Then cut below in the middle of the first column the target content and paste it into the second column. Now create a TM from your file, which you import into your project and simultaneously process it as a file (or your prepared excel file with the two columns). | | |
Gianni Pastore Italy Local time: 18:17 Member (2007) English to Italian Do you have Excel? | Feb 19 |
If so, I think the fastest way is to work in Excel, using some command (this depends on the Excel version you have) to select only odd and even rows and then copying/pasting the results side by side. | | |
Samuel Murray Netherlands Local time: 18:17 Member (2006) English to Afrikaans + ...
Ali Al awadi wrote: What is the best way to handle this task with memoQ? Unfortunately MemoQ can only handle multilingual Excel files that use columns, not rows. So, doing as Thomas suggests and converting the file to a format that has columns (in such a way that you can easily convert it back again) seems like a good bet. MemoQ does seem to have a feature whereby you can selectively exclude segments, by specifying the cells or the ranges, but that would only be useful if you were the *translator* for this task and you had identical text in the source and target cells. | | |
Stepan Konev Russian Federation Local time: 19:17 English to Russian
Could you please share a screenshot of your file? Not necessarily the true text, but just a layout (header, blank rows between segments, etc.). You gave two examples above: === Target Source Target source Target Source === and === Source Target Source Target Source Target === but they are different layouts and it does matter for the solution.
[Edited at 2024-02-19 16:... See more Could you please share a screenshot of your file? Not necessarily the true text, but just a layout (header, blank rows between segments, etc.). You gave two examples above: === Target Source Target source Target Source === and === Source Target Source Target Source Target === but they are different layouts and it does matter for the solution.
[Edited at 2024-02-19 16:01 GMT] ▲ Collapse | |
|
|
...with only the target content of the FIRST column! | Feb 19 |
Matthias Brombach wrote: ...by naming the first cell of the second column L and the second R, copy both cells, mark the rest of the second column, paste the both cells entirely into it and then filter the entire file by the second column. Then cut below in the middle of the first column the target content and paste it into the second column. Now create a TM from your file, which you import into your project and simultaneously process it as a file (or your prepared excel file with the two columns). I was wrong with the last part, so please either take the TM file export or only the target content of the FIRST column! I guess that you can help yourself from now on and you should have caught my idea. Good luck! | | |
|
Stepan Konev Russian Federation Local time: 19:17 English to Russian Conversion in Word | Feb 19 |
Another option is to copy and paste the table from Excel to Word, then convert it to text, then convert it to table again with the wizard set to 2 columns. This would create a two column table. Once reviewed, convert it to text and then convert it to table again, this time with one column. Paste it ... See more Another option is to copy and paste the table from Excel to Word, then convert it to text, then convert it to table again with the wizard set to 2 columns. This would create a two column table. Once reviewed, convert it to text and then convert it to table again, this time with one column. Paste it back into Excel. ![](https://i.ibb.co/0jMyMTS/1-ezgif-com-video-to-gif-converter.gif) *I skipped the memoQ editing step, but I believe you know how to get a two-column table in Word with your edited target on the left and source on the right.
[Edited at 2024-02-19 20:23 GMT] ▲ Collapse | | |
Pages in topic: [1 2] > |