Put the separator every thousands

Question

Luca Re 2024-2-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2080666-put-the-separator-every-thousands

评论： Image Analyst 2024-2-11

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 2024-2-10

编辑：Stephen23 2024-2-10

在 MATLAB Online 中打开

"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 2024-2-10

Yes, I counted the zeros wrong :DI to communicate 1000000000 become should 1'000'000'000

请先登录，再进行评论。

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

Answer 1

Stephen23 2024-2-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2080666-put-the-separator-every-thousands#answer_1406126

编辑：Stephen23 2024-2-10

在 MATLAB Online 中打开

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Luca Re 2024-2-10

Good 👍👍

请先登录，再进行评论。

Answer 2

Image Analyst 2024-2-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2080666-put-the-separator-every-thousands#answer_1406121

CommaFormat.m

I use the attached function I wrote. Adapt as needed, like change commas to apostrophes if you want.

2 个评论
显示无隐藏无

Stephen23 2024-2-10

在 MATLAB Online 中打开

CommaFormat.m

CommaFormat('-123456') % ouch
ans = '-,123,456'

Image Analyst 2024-2-11

CommaFormat.m

@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.

请先登录，再进行评论。