Converting numbers in brackets to negative numbers

Question

Hi! 
 I'm translating an annual report where all negative numbers in tables are set in brackets (instead of using minus signs). In the Swedish translation, all these numbers must be written with minus signs. Example: (5,000.00) in the English original should be written as -5 000,00 in the Swedish translation. 
 Is there a standard setting for this or some other clever way of doing it? I can obviously change all the numbers in the target file manually, but then I can't use number verification - and I will have to redo the process each time the client sends me a new version of the files. It is not unusual to go through several drafts when working on annual reports, so this would be a major pain. 
 Kind regards, 
 Johanna

Lydia Simplicio · Answer

Johanna Liljenzin YES! I am sure there are many ways this can be achieved but you would need to now some regex which should remove the (), replace with - and manage the decimal placement I personally I would look at SDLXLIFF Toolkit or Regex Match AutoSuggest Provider 
 Jesús Prieto may have a few pointers for you 
 Lyds

Jesús Prieto · Answer

Johanna Liljenzin , 
 This would be the SDLXLIFF Toolkit way mentioned by Lydia: 
 
 First, make a backup of the project, just in case there is something goes wrong&hellip; 
 Install the plugin SDLXLIFF Toolkit from https://appstore.rws.com/Plugin/77 
 In Trados, open the Files or the Projects view and then the Toolkit tab (with the Swiss knife icon). You will see something like this.

Now open Windows Explore r and go to the project folder and then go to the target folder. For example, translating into Swedish it may be the folder sv-se . If there is only one file, drag and drop the target XLIFF (alternatively you can select the button Select sdlxliff files&hellip; ). If there are several files included in the project, clicking the button Select project file will be quicker. 
 Open the Replace tab. 
 Tick the Use regular expressions check box. 
 Insert the following regexes in the fields: Source search : $([0-9.,]+?)$ Replace with : -$1 Note: this is a hyphen (-) as I see on your post, not a minus sign (&minus;) as you mentioned. 
 Optional: Click on the Find All button to check that the app finds instances. 
 Optional: Click on the Preview button to confirm that the shown replacements are what you need: 
 Click on the Replace All button. 
 Open the XLIFF in Editor as usual and all your (1.234,4) strings should have been replaced with -1.234,4 . 
 Done! 
 
 Again: there is no Undo button, so you'd better create a backup of the full project before running this app.

Trados Studio > 1. Trados Studio

Converting numbers in brackets to negative numbers