Hi
Can anybody help to find a regex detecting in target all numbers that do not contain a dot as thousands separator?
Many thanks in advance
Simone
![5 stars click here to know more emoji](https://community.rws.com/cfs-filesystemfile/__key/widgetfiles/5c4647e932a14e22b262d374e00bf337-d/5star.png?_=638586179635030146)
Hi
Can anybody help to find a regex detecting in target all numbers that do not contain a dot as thousands separator?
Many thanks in advance
Simone
Hi Simone,
Try this... \d(?!.*\.).\d\d\d
I think that should find thousand, million separators, etc., though it might also flag up decimals with more than 2 decimal places...
Fingers crossed... someone less rusty at regex than I may have a more appropriate suggestion
All the best,
Ali
PS: If you insert that in the Display Filter on the Review tab (ribbon), selecting 'In Target', it will recognise the regex.
Alternatively, insert it into the Target line of the Advanced Display Filter, having ticked 'Regular Expression', as follows:
Ali
Hi Alison,
Thank you for your quick reply.
It found me the below:
But the below ones are not detected, do you have any suggestion?
Hi Simone,
It found the longer numbers because the regex is searching for one number followed by anything except a full stop then 3 more numbers.
To add a search for thousands without a space, the following should work (using the pipe divider equals 'or')
\d(?!.*\.).\d\d\d|\d\d\d\d
Let me know if it works OK!
All the best,
Ali
it works!!!
Thank you!
Simone
Hi Simone,
I'm pleased it worked for you!
All the best,
Ali
If you want to learn more about any aspect of working with Trados, can I also suggest you take advantage of the new ideas for training hub that Paul has recently set up, where people can add requests for informal training sessions: Ideas for training