# Check for missing full stop as thousand seperator

**URL:** <https://forum.xbench.net/t/check-for-missing-full-stop-as-thousand-seperator/1127>\
**Category:** General Discussion\
**Created:** [April 4, 2024, 7:02am UTC](https://forum.xbench.net/t/check-for-missing-full-stop-as-thousand-seperator/1127 "2024-04-04T07:02:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Simone](https://avatars.discourse-cdn.com/v4/letter/s/cab0a1/32.png) [@Simone](https://forum.xbench.net/u/Simone)\
**Post date:** [April 4, 2024, 7:02am UTC](https://forum.xbench.net/t/check-for-missing-full-stop-as-thousand-seperator/1127/1 "2024-04-04T07:02:47Z")

</div>

Hi  
I need to find all numbers starting from 3 digits in target that not contain a full stop as thousand seperator.

Can anyone help please?

---

<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:** [April 4, 2024, 7:21am UTC](https://forum.xbench.net/t/check-for-missing-full-stop-as-thousand-seperator/1127/2 "2024-04-04T07:21:16Z")

</div>

Try the following search:

Target term: `<[0-9]{,3}[^\.][0-9]{3}>`

If the number in source has comma as thousand separator, try this one:

Source term: `"<([0-9]{,3})=1,([0-9]{3}>)=2"`  
Target term: `-"@1\.@2"`

In both cases, select Regular Expressions as search mode and PowerSearch.

---

<div class="post-metadata">

**Author:** ![Simone](https://avatars.discourse-cdn.com/v4/letter/s/cab0a1/32.png) [@Simone](https://forum.xbench.net/u/Simone)\
**Post date:** [April 4, 2024, 7:46am UTC](https://forum.xbench.net/t/check-for-missing-full-stop-as-thousand-seperator/1127/3 "2024-04-04T07:46:19Z")

</div>

Thank you

It detects if there are not full stops as separators for 10000 numbers but it doesn’t detect for 1000 numbers

Best Regards

---

<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:** [April 4, 2024, 8:24am UTC](https://forum.xbench.net/t/check-for-missing-full-stop-as-thousand-seperator/1127/4 "2024-04-04T08:24:03Z")

</div>

I tried the search and it worked on my side. Try this other one.

Source term: `"<([0-9]{1,3})=1,([0-9]{3}>)=2"`  
Target term: `-"@1\.@2"`  
Search mode: Regular Expressions  
PowerSearch: on.

---

<div class="post-metadata">

**Author:** ![Simone](https://avatars.discourse-cdn.com/v4/letter/s/cab0a1/32.png) [@Simone](https://forum.xbench.net/u/Simone)\
**Post date:** [April 4, 2024, 8:30am UTC](https://forum.xbench.net/t/check-for-missing-full-stop-as-thousand-seperator/1127/5 "2024-04-04T08:30:10Z")

</div>

Hi, it doesn’t work. I would keep the search in Target only because source variants are many, sometimes spaces, fullstop aor commas as sepatrator.

I tried this and seems to be working, could be?

Target term: `<[0-9]{,2}[^\.][0-9]{2}>`  
Search mode: Regular Expressions  
PowerSearch: on.