# Check for no thousand separators

**URL:** <https://forum.xbench.net/t/check-for-no-thousand-separators/517>\
**Category:** Technical Support\
**Created:** [July 24, 2019, 7:54am UTC](https://forum.xbench.net/t/check-for-no-thousand-separators/517 "2019-07-24T07:54:07Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![omartin](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.xbench.net/omartin/32/82_2.png) [@omartin](https://forum.xbench.net/u/omartin)\
**Post date:** [July 24, 2019, 1:20pm UTC](https://forum.xbench.net/t/check-for-no-thousand-separators/517/2 "2019-07-24T13:20:51Z")

</div>

Hi Robert,

This search should fit your needs and find all those numbers with spaces, commas and dots as thousands separators in the source text that do not contain any separator in target.

Source term: `"([1-9]{,3})=1[,\.[:space:]]?(([0-9]{3})+)=2"`  
Target term: `-@1[,\.[:space:]]@2`  
PowerSearch: On.  
Search Mode: Regular Expressions.

`([1-9]{,3})=1` means up to 3 digits between 0 and 9.  
[,.[:space:]]? means 0 or 1 instance of comma, dot or space.  
(([0-9]{3},?)+)=2 means 3 digits between 0 and 9.

Please note that you are also searching numbers that do not contain any thousand separator in source.

Regards,

Oscar.

---

_[View the full topic](https://forum.xbench.net/t/check-for-no-thousand-separators/517)._
