Hello!
Can you please tell me what regular expression can be used to divide a multi-digit number/decimals into class numbers with non-breaking spaces
Only thing that worked looks very strange and it's not multipurposal.
E.g. for 9-digit number I used Find&Replace function
123456789
Find what: ([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])
Replace with: $1$2$3$ 4$5$6$ 7$8$9
This one could be used, but it absolutely useless with decimals
I think a few more examples would be good. For example the numbers could be these based on your description:
1,234,567.432234
3,45
3 456 567,2
Or do you mean multidigit numbers that have just not been given the thousand/decimal separators? In which case what do yo do with this?
123456789
It could be any of these I suppose:
1,234,567.89
12,345,678.9
123,456,789
12,345.6789
1,234.56789
123.456789
I used commas and point to illustrate the point... I know you asked for spaces, but you also said decimals. So where does the decimal go?
To expand what Paul said: the basic "key" to coding a regex is to define the processing rules.
Thank you Phil for your answer.
All your examples are relevant. (But if you can help me to divide integers without taking decimals it will be a great job too)
I had a table with a lot of so kind of numbers
I wanted to divide into classes just integers, there were thousands, millions, billions, etc.
For these tasks I used:
Find what: ([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])
Replace with: $1$2$3$ 4$5$6$ 7$8$9
then
Find what: ([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])
Replace with: $1$2 $3$4$5 $6$7$8
etc. (every next step I I shortened the expression by one digit)
But sometimes there were some decimals, and I had to do a lot of work just manually. So I'm trying to find more convenient way to work with this.
Thank you
Because native regex has only limited formatting capabilities, it may be better to run a regex pair, where the first general regex performs the basic extraction and formatting, and the second regex performs the cleanup.
For example,
\b(\d{1,3})(\d{3})?(\d{3})?(\.(\d+))?\b
with replacement expression
$1 $2 $3,$5
handles numbers with 1-9 digits before an optional period and 1 or more digits after an optional period. The regex could easily be extended to handle larger numbers.
An alternative approach would be to code separate regexes to handle each number combination and execute them manually or automated (such as with AHK)
Test strings:
1 12 123 1234 12345 123456 1234567 1234567.93
Associated result strings:
1 , 12 , 123 , 1 234 , 12 345 , 123 456 , 1 234 567, 1 234 567,93
A cleanup regex removes any superfluous punctuation.
Thank you, Anthony! That's what I wanted. It works
Translate
