Segment after TAB tag in bilingual Excel file
Շարքի հրապարակողը: Jalapeno

Jalapeno
Local time: 19:53
անգլերենից գերմաներեն
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
Իսպանիա
Local time: 19:53
Անդամ
անգլերենից ֆրանսերեն
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






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 »
TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »



Forums
  • All of ProZ.com
  • Բառերի որոնում
  • Պատվերներ
  • Ֆորումներ
  • Multiple search