Regexes for changing currency amounts from source to target (German to English)

Question

For a piece I am currently doing, I have a lot of amounts (fines etc. imposed) in the text that use two different Austrian standards for presenting the amount of the fine: They have the following formats. 
 EUR 600,-- EUR 1 250,-- 726,-- EUR 1.400,-- EUR 78,50 EUR 
 Is there a way using Regex to: 
 
 Change the number in the target segment (English) to have the currency code before the amount. 
 Change the -- after the decimal comma into 00 
 Harmonise the thousands separator (non-breaking space or .) 
 Add these to the currency formats in Studio 2021.

Raphaël Toussaint · Accepted Answer

[deleted]

Raphaël Toussaint · Answer

Interesting query, Michael! 
 In addition to the already provided solutions, there is one more I can think of, once again with the help of a Studio app and regular expressions. The app in question is the AutoSuggest Provider , where you could use the following search and replace patterns:

Regex Pattern 
 RegEx Replacement 
 Comment

EUR[ ]*(\d+),-- 
 EUR $1.00 
 Replace ",--" by ".00" Make sure there is a non-breaking space between "EUR" and amount

(?<!\d[\. ])(\d+),--[ ]*EUR 
 EUR $1.00 
 Replace ",--" by ".00" Put "EUR" in front of amount Make sure there is a non-breaking space between "EUR" and amount (for amounts smaller than 1000)

EUR[ ]*(\d{1,3}),(\d{2}) 
 EUR $1.$2 
 Replace decimal separator "," by "." Make sure there is a non-breaking space between "EUR" and amount

(?<!\d+[\. ])(\d{1,3}),(\d{2})[ ]*EUR 
 EUR $1.$2 
 Replace decimal separator "," by "." Put "EUR" in front of amount Make sure there is a non-breaking space between "EUR" and amount (for amounts smaller than 1000)

EUR[ ]*(\d{1,3})[\. ]?(\d{3}),-- 
 EUR $1 $2.00 
 Replace ",--" by ".00" Use non-braking space as thousands separator Make sure there is a non-breaking space between "EUR" and amount

(\d{1,3})[\. ]?(\d{3}),--[ ]*EUR 
 EUR $1 $2.00 
 Replace ",--" by ".00" Put "EUR" in front of amount Use non-braking space as thousands separator Make sure there is a non-breaking space between "EUR" and amount

EUR[ ]*(\d{1,3})[\. ]?(\d{3}),(\d{2}) 
 EUR $1 $2.$3 
 Replace decimal separator "," by "." Use non-braking space as thousands separator Make sure there is a non-breaking space between "EUR" and amount

(\d{1,3})[\. ]?(\d{3}),(\d{2})[ ]*EUR 
 EUR $1 $2.$3 
 
 Replace decimal separator "," by "." Put "EUR" in front of amount Use non-braking space as thousands separator Make sure there is a non-breaking space between "EUR" and amount

Please note that I didn't have the time to verify/test the patterns. I hope this helps nevertheless.

Anthony Rudd · Answer

For example (this assumes well-formed currency values) (?=.*EUR)(EUR\s?)?((?\d{1,3})([. ](?\d{3}))?([,](?\d{2}|--))?)(\s?EUR)? With replace string EUR ${m1},${m2}.${n} Cleanups (to correct incorrect formatting) (\d{1,3})(,\.)(\D|$) Replace string: $1.00 (\d{1,3})(,\.)(\d{2}) Replace string: $1.$2

Jesús Prieto · Answer

Hi Michael Bailey , 
 I'd use TermInjector plugin and use one regex per case (divide and rule).

Paul · Answer

Michael Bailey 
 Michael Bailey said: Change the number in the target segment (English) to have the currency code before the amount. 
 Change the -- after the decimal comma into 00 
 Harmonise the thousands separator (non-breaking space or .) 
 Great solution from Anthony Rudd ... good to see the regex experts stepping in. 
 Michael Bailey said: Add these to the currency formats in Studio 2021. 
 I don't think this is really possible, at least not in the same document. For example, you cannot have EUR before the amount AND after the amount: 
 
 You also won't be able to pick up on the use of the double dash -- 
 So I think your best bet is the search & replace provided by Anthony, or us terminjector as suggested by Jesús Prieto .

Anthony Rudd · Answer

You can certainly use regex to process such strings. Unfortunately, regex has only limited substitution capabilities. This means separate regexes (or alternatives) would be required for most cases, such as 1-3 digits, 4-6 digits, 7-9 digits, etc. If there are only the above cases need to be processed, this would be feasible 
 .

Trados Studio > 5. Regex and XPath

Regexes for changing currency amounts from source to target (German to English)

Top Replies