Segment after TAB tag in bilingual Excel file
Autor vlákna: Jalapeno

Jalapeno
Local time: 15:20
angličtina -> němčina
Jun 12

Hi there,

I have a bilingual Excel file that I need to translate in memoQ. Source text in column A, target text with some existing translations in column B, context information in column C. I've managed to import that perfectly with one little exception:

Some of the source strings start with the name of a person followed by a colon followed by a TAB tag followed by what the person says. After import, this shows up in memoQ like this:

Speaker:TABThis is what
... See more
Hi there,

I have a bilingual Excel file that I need to translate in memoQ. Source text in column A, target text with some existing translations in column B, context information in column C. I've managed to import that perfectly with one little exception:

Some of the source strings start with the name of a person followed by a colon followed by a TAB tag followed by what the person says. After import, this shows up in memoQ like this:

Speaker:TABThis is what the speaker says.

I want it to show up like this:

Segment 1 - Speaker:
Segment 2 - This is what the speaker says.

I've tried playing around with segmentation rules and filters, but I can't get it to work.

Any memoQ / RegEx wizards with bright ideas around?

Thanks in advance for any help


[Edited at 2020-06-12 13:17 GMT]
Collapse


 

Philippe Etienne  Identity Verified
Španělsko
Local time: 15:20
Člen
angličtina -> francouzština
A pity it's not a Word file Jun 12

To split segments at tabs in a Word file:
Import with options
Change filter and configuration
General tab > Special Characters pane > Tab drop-down list > Start new segment

But it's an Excel file, and there isn't any similar option in my v.2013 R2 version...

Philippe


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Segment after TAB tag in bilingual Excel file

Advanced search






Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

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
  • Vyhledávání termínů
  • Zakázky
  • Fóra
  • Multiple search