Find/replace - remove a space in 4 digit numbers

[lalywizz]

Hi there. In my text, I would like to remove the space for every 4 digits numbers (ex. 2 000 becomes 2000). However, I also have numbers of 1 000 000 or more in this text which thousands are separated by spaces. And by removing the spaces for every 4 digits numbers, I don't want it to affect the numbers of 1 000 000 or more (i.e. I don't want the number "1 000 000" to become "1000 000" because of this change).

I'm looking for a way to do a find/replace (using wildcards) so that 4 digit numbers don't contain a space, but for numbers 1 000 000 and above, the space remains present.

Any suggestion? Thanks.

[lalywizz]

Ok, nevermind, I found the solution myself.

For those interested, once I remove space for all 4 digit numbers, the numbers of 1 000 000 or more look like this: 1000 000. Then I did a Find/replace using wildcards. I did enter:

([0-9]{1})([0-9]{3}) ([0-9]{3})

Note there is a space before the last sequence.

In the Replace with: I did enter

\1 \2 \3

So 1000 000 becomes 1 000 000. Exactly what I was looking for.

Cheers.

[macropod]

A single wildcard Find/Replace would suffice:
Find = ([!0-9]?[0-9]@) ([0-9]{3}?[!0-9])
Replace = \1\2

[lalywizz]

Originally Posted by macropod

A single wildcard Find/Replace would suffice:
Find = ([!0-9]?[0-9]@) ([0-9]{3}?[!0-9])
Replace = \1\2

This one doesn't work... I got 0 result.

[macropod]

Works for me. With text like:

numbers of 1 000 000 or more and numbers of 1 000 or more

the result is:

numbers of 1 000 000 or more the numbers of 1000 or more

[lalywizz]

You're right! It's working! I probably included a space when I did copy/paste the first time.

Good work! Thanks!