Copy source to target with auto-conversion of numeric format ?
Thread poster: Daniel Arnold

Daniel Arnold
Local time: 07:35
Member (2013)
German to English
+ ...
Nov 9, 2015

Hello everyone,

I was wondering if there is a function, shortcut or macro that I can use in SDL Trados Studio 2015 where lines that contain only a number are copied to the destination (automatically) AND at the same time the number format is adjusted to the rules for the target language ?


Source (German) Target (EN-US)
€302.276,09 €302,276.09

Note how the "," and "." have changed position.

So far when I copy from source to target, the formatting does not adjust automatically. This is a huge disadvantage when translating a large volume of financial documents. Is there a function I have overseen, or is a plug-in or alike available ?

I look forward to your response.


Nora Diaz  Identity Verified
Local time: 23:35
Member (2002)
English to Spanish
+ ...
How about using regex? Nov 10, 2015

What I would do is:

1. Filter to show only the desired segments , which can be done with a regex like ^€\d+\.\d+,\d+$
2. Select all the displayed segments, copy source to target
3. Do a Find and Replace using the following regex:

Find: (\d+)\.(\d+),(\d+)
Replace with: $1,$2.$3


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

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

Copy source to target with auto-conversion of numeric format ?

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 »
BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »

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