Effacer les filtres
Effacer les filtres

Put the separator every thousands

10 vues (au cours des 30 derniers jours)
Luca Re
Luca Re le 10 Fév 2024
Commenté : Image Analyst le 11 Fév 2024
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 commentaires
Stephen23
Stephen23 le 10 Fév 2024
Modifié(e) : Stephen23 le 10 Fév 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 le 10 Fév 2024
Yes, I counted the zeros wrong :DI to communicate 1000000000 become should 1'000'000'000

Connectez-vous pour commenter.

Réponse acceptée

Stephen23
Stephen23 le 10 Fév 2024
Modifié(e) : Stephen23 le 10 Fév 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"
  1 commentaire
Luca Re
Luca Re le 10 Fév 2024
Good 👍👍

Connectez-vous pour commenter.

Plus de réponses (1)

Image Analyst
Image Analyst le 10 Fév 2024
I use the attached function I wrote. Adapt as needed, like change commas to apostrophes if you want.
  2 commentaires
Stephen23
Stephen23 le 10 Fév 2024
CommaFormat('-123456') % ouch
ans = '-,123,456'
Image Analyst
Image Analyst le 11 Fév 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.

Connectez-vous pour commenter.

Catégories

En savoir plus sur Characters and Strings dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by