Put the separator every thousands

8 views (last 30 days)
T=100000000;
T1 = regexprep(string(T),'(\d+)(\d{3})$',"$1'$2")
T1 = "100000'000"
I would like to have the thousands separator for every 1000
the correct result would be:
1'000'000'000
  2 Comments
Stephen23
Stephen23 on 10 Feb 2024
Edited: Stephen23 on 10 Feb 2024
"the correct result would be: 1'000'000'000"
Why should the "correct result" be one billion when the input value is only one hundred million?
100000000 % your input value
1000000000 % your "correct result" with quotes removed
Your "correct result" is ten times larger than the input value: is that intentional or is it ... incorrect ?
Luca Re
Luca Re on 10 Feb 2024
Yes, I counted the zeros wrong :DI to communicate 1000000000 become should 1'000'000'000

Sign in to comment.

Accepted Answer

Stephen23
Stephen23 on 10 Feb 2024
Edited: Stephen23 on 10 Feb 2024
Here are some more interesting testcases (with both one hundred million as well as one billion):
S = ["100000000";"1000000000";"123456789.123456789";"-123456789";"0";pi;"1e23456"]
S = 7×1 string array
"100000000" "1000000000" "123456789.123456789" "-123456789" "0" "3.1416" "1e23456"
S = regexprep(S,"(?<![eE\.]\d*)\d{1,3}(?=(\d{3})+\>)","$&'")
S = 7×1 string array
"100'000'000" "1'000'000'000" "123'456'789.123456789" "-123'456'789" "0" "3.1416" "1e23456"

More Answers (1)

Image Analyst
Image Analyst on 10 Feb 2024
I use the attached function I wrote. Adapt as needed, like change commas to apostrophes if you want.
  2 Comments
Stephen23
Stephen23 on 10 Feb 2024
CommaFormat('-123456') % ouch
ans = '-,123,456'
Image Analyst
Image Analyst on 11 Feb 2024
@Stephen23 thanks for pointing that out. I've corrected it to properly handle cases where the input is negative or a string or a character array instead of a number (double, etc.). New code is attached.
It's definitely more lines than your one liner regexp though. However I'm not as adept with regexp as you -- I never would have figured out that cryptic sequence of regexp characters as you did.

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!