thousand separators in Regex Match Autosuggest Provider

Question

Could someone give me the regex pattern and replacement pattern to replace blank thousands separators with commas? That is to say, 15 789 489 with 15,789,489. Thanks.

Paul · Answer

Lewis Paines 
 Is this a search & replace operation or something else? 
 Are the numbers always like that or could there be these: 
 1 234 567 678 1 234 567 1 234 21 234 567 678 12 234 567 11 234 131 234 567 678 211 234 567 981 234 
 Or more?

Paul · Answer

Lewis Paines 
 At a very simple level you might get away with this: 
 (\d)\s(\d) 
 $1,$2

Paul · Answer

Lewis Paines 
 I asked you if this was a search and replace and you said yes. It will not achieve what you're after with the Regex Match AutoSuggest Provider. I thought you were letting Studio do it's thing and needed to run a search and replace afterwards. 
 To do what you want in the regex autosuggest provider I think you'll need to create multiple rules... maybe something like this: 
 \b(\d{1,3})\s(\d{1,3})\s(\d{1,3})\s(\d{1,3})\b 
 $1,$2,$3,$4 
 \b(\d{1,3})\s(\d{1,3})\s(\d{1,3})\b 
 $1,$2,$3 
 \b(\d{1,3})\s(\d{1,3})\b 
 $1,$2 
 Maybe someone else has a clever way of doing this in one... would love to know what this would be myself!

Anthony Rudd · Answer

This is an interesting problem that should be easy to solve! The best approach I can suggest is hardly clever, more "brute force" with 2 generalised regexes 
 regex 1: \b(\d{1,3})(\s(\d{3}))?(\s(\d{3}))?(\s(\d{3}))?\b replace string: $1,$3,$5,$7 
 This handles numbers up to 10**12 
 The following regex cleans up the superfluous commas 
 regex 2: ((\d)*(,\d)*),*() replace string: $1$4

Trados Studio > 5. Regex and XPath

thousand separators in Regex Match Autosuggest Provider