Check for missing full stop as thousand seperator

General Discussion
1

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?

2

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.

3

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

4

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.

5

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.