Did you find this page useful? Give us feedback.
Did you find the information
on this page useful?

  Tell us more about your choice:
Missing information
Incorrect information
Misleading information
I have a question
  Enter your comment in the box below.
If you need assistance, please contact Support instead.

  Type the letters
simple PHP captcha

This command will automatically fill in the translations of segments where the source text is just a number. It is useful when you need to translate tables that have hundreds or thousands of cells with nothing but numbers, and documents that contain facts and figures.

In addition to numbers, memoQ will recognize all sorts of placeables – measurements with units, non-translatable items, e-mail addresses, web addresses and other recognizable entities. When a segment contains nothing but one of these, the source text gets copied automatically.

memoQ will not simply copy the numbers: it will change their format, so that they match the target language. To configure how this happens, use the AutoPick settings in your project: on the Translation ribbon, click Translation Settings, choose Predictive Typing and AutoPick, and then click the AutoPick tab. In the AutoPick tab, review the settings in the Number format for target language section, and change them as you see fit. To learn more, see the topic on AutoPick.

How to begin

On the Preparation ribbon, choose Populate Number-Only Segments. The Populate number-only segments dialog appears:


Scope section:

Define your scope of what to populate: the whole project, selected documents, open documents, views, the active document only, from the cursor position or a selection of text. Enable the options accordingly.

Recognize what section:

Check the Numbers, non-translatables, e-mails, URLs, other entities check box to recognize all the placeables that are defined in the AutoPick settings. Non-translatables have priority over everything else.

For numbers, memoQ will recognize the following items:

measurements even if they are separated from the number with a space;

sequences such as 4x5 or 3 x 4 x 12;

entities like serial numbers, car registration plate numbers, etc. (A78/B12, a2r4e3-12ew34 are recognized as numbers);

characters with /\--* within alphanumberic sequences;

full-width numbers with full-width comma and period as in U+ff0c;

formats as .5 for English as a valid number and transforms it to 0.5 or 0,5 into any other non-English languages

numbers grouped with an apostrophe.

Check the Auto-translatables check box to run auto-translation rules on the contents of the source segment. If the source cell contains auto-translatables in addition to numbers and non-alphabetic characters (but nothing else), the rules will also run. What's more, they will always have precedence over numbers (even if they cover several numbers and other characters), except if the number recognizer recognizes a longer sequence (e.g. a number with a measurement). If the auto-translatable rule also recognizes a non-numerical part, that part will be transformed, too.

Note: If there are any other alphabetical characters not covered by auto-translatables or numbers, memoQ will not fill in the target cell automatically.

Note: You need to check at least one of these check boxes to fill in the number-only segments.

Self-confidence section:

Use the settings here to make memoQ more eager when recognizing and filling in non-textual segments.

Segments with multiple numbers: Check this check box to populate segments with multiple numbers, for example: 2, 4, 7.

Non-alphabetical characters or tags besides numbers: Check this check box to populate tags besides numbers and characters like a non-breaking space.

Populate unconfirmed rows with text in target: Check this check box to populate segments like 5kg or 50%.

Note: If the Insert space to separate unit of measurement check box is checked in the AutoPick settings, that will affect the way measurement units are filled in. For example, you have 5kg in your source. It will be populated  to 5 kg. A space is added.

Status of populated segments section:

memoQ will change the status of segments it fills in automatically. Choose which status to use in this section. You can choose between Confirmed (green) or Assembled from fragments (purple). To lock the segments that are filled in, check the Lock rows check box.


Click OK to save your changes and run the command through your document or documents. Click Cancel to leave the dialog without making changes.


See also: Knowledge Base on Numbers in memoQ