Put the separator every thousands

8 次查看（过去 30 天）
Luca Re
Luca Re 2024-2-10
评论： Image Analyst 2024-2-11
Ran in:
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 个评论
Stephen23
Stephen23 2024-2-10
编辑：Stephen23 2024-2-10
"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 2024-2-10
Yes, I counted the zeros wrong :DI to communicate 1000000000 become should 1'000'000'000

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Stephen23
Stephen23 2024-2-10
编辑：Stephen23 2024-2-10
Ran in:
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 个）

Image Analyst
Image Analyst 2024-2-10
I use the attached function I wrote. Adapt as needed, like change commas to apostrophes if you want.
  2 个评论
Image Analyst
Image Analyst 2024-2-11
@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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by