how to prepare segmentation rules for excel files?
Thread poster: Bartek Zukowski

Bartek Zukowski
Local time: 22:26
English to Polish
+ ...
Oct 27, 2011


I recently installed memoQ and my first impression is very positive - it seems to have all options that Wordfast lacks and is more intuitive than Trados.

But there is one thing that is a problem for me: I don't know how to set segmentation rules using regular expressions to split excel files by whole cells (not sentences). In Wordfast and Trados it is fairly simple because you only need to find the proper option in segmentation rules' settings and turn it on. In memoQ you have to prepare a rule for yourself and memoQ help file gives only basic insight in regular expressions.

Could anyone help me with it? Probably it's very simple. I hope it is

Thanks in advance for any help in this matter!

Direct link Reply with quote

Epameinondas Soufleros  Identity Verified
Local time: 23:26
Member (2008)
English to Greek
+ ...
Very simple Oct 27, 2011

You'll have to open the resource console, go to Segmentation Rules, clone the default rules, press "Edit" and clear all rules therein. This way, memoQ will not follow any rules, hence it will import the entire cells as they appear in Excel.

I have made this rule for my own use, so I can e-mail to you, if my instructions are not clear enough.

Direct link Reply with quote

Gail Bond MITI  Identity Verified
United Kingdom
Local time: 21:26
Member (2009)
French to English
Email support Oct 27, 2011

When I needed to set complex regex rules, it was all a bit beyond me so I emailed Kilgray support and they sent me the codes to enter. I would never have worked it out for myself... looks like gibberish to me! But it works!

Direct link Reply with quote

Bartek Zukowski
Local time: 22:26
English to Polish
+ ...
Thanks! Oct 28, 2011

Thanks Epameinondas! Indeed it is very simple

And thanks Gail for your advice. I will contact Kilgray support in case of any future problems.

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 segmentation rules for excel files?

Advanced search

CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

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 »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search