Currency format in Populate number-only segments
Thread poster: Kathleen Misson
Kathleen Misson
Kathleen Misson  Identity Verified
Spain
Local time: 17:30
Member (2009)
Spanish to English
Apr 4, 2023

Hello,

When I use Populate number-only segments, the figures are translated as:

17.50 €​

How could I have them translated as:

€17.50

Thank you.


 
Stepan Konev
Stepan Konev  Identity Verified
Russian Federation
Local time: 18:30
English to Russian
Details Apr 4, 2023

What is your language pair and can you give an example of your source segment?

 
Kathleen Misson
Kathleen Misson  Identity Verified
Spain
Local time: 17:30
Member (2009)
Spanish to English
TOPIC STARTER
Spanish to English Apr 4, 2023

the source is:

17,50 €

the automatic target is

17.50 €

the desired target is

€17.50

Many thanks.


 
Stepan Konev
Stepan Konev  Identity Verified
Russian Federation
Local time: 18:30
English to Russian
Replace with regex Apr 4, 2023

There seems to be no option for your task out of the box, but you can use a regex-based operation.
1. Click the gear icon to check the 'Use regex' box.
2. Type ^(\d+),(\d+)\s(€)$ in the Source field and press Enter.
3. Press Ctrl+Shift+A to select all the filtered segments.
4. Copy source to target (Ctrl+Shift+S by default).
5. Press Ctrl+H and type the following regular expressions:
Find what: (\d+),(\d+)\s(€)
Replace with: $3$1,$2
6. C
... See more
There seems to be no option for your task out of the box, but you can use a regex-based operation.
1. Click the gear icon to check the 'Use regex' box.
2. Type ^(\d+),(\d+)\s(€)$ in the Source field and press Enter.
3. Press Ctrl+Shift+A to select all the filtered segments.
4. Copy source to target (Ctrl+Shift+S by default).
5. Press Ctrl+H and type the following regular expressions:
Find what: (\d+),(\d+)\s(€)
Replace with: $3$1,$2
6. Click 'Replace all' (Alt+A)


[Edited at 2023-04-04 16:36 GMT]
Collapse


John Fossey
SKLIANCHUK YULIIA
 
Kathleen Misson
Kathleen Misson  Identity Verified
Spain
Local time: 17:30
Member (2009)
Spanish to English
TOPIC STARTER
solved Apr 4, 2023

Brilliant. That works perfectly. Thanks so much for your help!

Stepan Konev
 
Stepan Konev
Stepan Konev  Identity Verified
Russian Federation
Local time: 18:30
English to Russian
Replace , with . Apr 4, 2023

Probably you could do it already, but just in case... I forgot to replace comma with dot. It must be $3$1.$2 in step 5.

SKLIANCHUK YULIIA
 
Kathleen Misson
Kathleen Misson  Identity Verified
Spain
Local time: 17:30
Member (2009)
Spanish to English
TOPIC STARTER
yes, I picked up on that Apr 4, 2023

Many thanks, it will be very helpful.

 
Laurent Di Raimondo
Laurent Di Raimondo  Identity Verified
France
Local time: 17:30
English to French
+ ...
SITE LOCALIZER
There is an easier way to get it Apr 10, 2023

If I may, there is an easier way to get it without using regex:

Once your project is set up in accordance with your preferences (including your language pair), you just need to create from scratch (or use any existing) translation memory. One important set-up not to forget: in the "Resource console", select "Numbers-English-Group" in the "Auto-translation rules" tab.

Then, when you come to the first segment with currencies values inserted, simply apply manually the prop
... See more
If I may, there is an easier way to get it without using regex:

Once your project is set up in accordance with your preferences (including your language pair), you just need to create from scratch (or use any existing) translation memory. One important set-up not to forget: in the "Resource console", select "Numbers-English-Group" in the "Auto-translation rules" tab.

Then, when you come to the first segment with currencies values inserted, simply apply manually the proper translation according to the target language: in your example, translate 17,50 € as €17.50 and confirm the segment.

After confirmation, your TM will register - and therefore remember - the correction you've so applied.

From that point, when navigating into every segment with another currency value inserted (even with a different amount), your TM will recognize the currency previously confirmed and will provide the right proposal adapted accordingly in the results field (top right window). For example, if (say) the value 178,81 € comes to a next segment, you will be offered the corresponding translation as €178.81 in your target language.

In order to propagate the result to all following segments containing the same currency symbol, you also may apply the pre-translate function by selecting "pre-translation from my TM" (any machine translation must be unticked at this stage, although you may enable it at will afterwards). And it works like a charm: each segment containing any € value will be auto-translated with help of both your TM and memoQ automatic recognition system.

[Modifié le 2023-04-11 04:02 GMT]
Collapse


Stepan Konev
 
Kathleen Misson
Kathleen Misson  Identity Verified
Spain
Local time: 17:30
Member (2009)
Spanish to English
TOPIC STARTER
thank you this helped Apr 11, 2023

I deleted all the other languages (numbers) under autotranslation rules and just left english numbers, now it works. Happy days.

 


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


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

Currency format in Populate number-only segments






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 »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »