Renato Colonna Rosman

You could use something like this:

Search for:

\d(?=(?:\d{3})+(?!\d))

Replace with:

$0,

Renato Colonna Rosman

Be careful though!!!  This is based on exactly what you asked for and won't be picky about any other types of numbers you have that might match this search.  If I was you I'd use the advanced display filter to filter the segments you want first, then reverse the filter and lock everything.  Then run the search & replace.

not working in version2017 (14.1.10018)

Dear Paul

Thank you very much for your kind attention, but the regular expression did not work in Trados Studio 2021 SR2 - 16.2.10.9305.

I selected, for example, the Target Segment containing only 16825.

Then I inserted the expression \d(?=(?:\d{3})+(?!\d)) in "Find What",

then I inserted the expression $0. (because I want to insert thousand dot separator) in "Replace with",

then I selected "Look in" (Selection), then I chose "use" Regular expressions",

when I click on "Find Next", the cursor selects the number "[6]",

when I click on "Replace", I read the answer: "Find complete: no matches found". No thousand separator is inserted. I other words, the number 16825 is not modified to 16.825, it remains as 16825.

The correct Regular Expressions for Trados Studio should be related to ".NET implementation". I have tested several Regular expressions (.NET implementation) in order to insert one or more thousand separators (as dot (.)) in numbers, but without any success.

Best regards

Your description is the identical experience which I've had with version2017.

Renato Colonna Rosman Kelly Edward

The problem, it seems, isn't with the regular expression.  The problem is that Trados Studio, all versions, doesn't handle the replace.  It'll find the correct location each time but the replace expression is completely ignored.  I'm pretty sure there is an existing bug for this but I'll log it again to make sure.

The solution, or at least one solution, is to install the SDLXLIFF Toolkit from the appstore as this will do it correctly.  I created a short video in Trados Studio 2021 to show you how it works:

tiny toy

Just OneClick away..

Renato Colonna Rosman

The existing bug number is CRQ-25500 and this specific one is CRQ-29206.  The problem is apparently related to the lookahead part of the regex so search & replace doesn't fail all the time, but hopefully we'll address this in an update soon.

Dear Paul

Thank you very much for the solution using the SDLXLIFF Toolkit!

Best regards.

Dear Kelly Edward

Where did you find the app "ThousandSeparator numberFun.." for Trados Studio 2021?

Thank you for your kind attention.

Best regards.