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

Bartek Zukowski
Local time: 16:35
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 isicon_wink.gif

Thanks in advance for any help in this matter!


Epameinondas Soufleros  Identity Verified
Local time: 17:35
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.


Gail Bond  Identity Verified
United Kingdom
Local time: 15:35
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!


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

Thanks Epameinondas! Indeed it is very simpleicon_smile.gif

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


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 »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »

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