How do I add commas to numbers using fprintf?

149 次查看（过去 30 天）
Bill Rooker
Bill Rooker 2017-3-8
评论： Stephen23 2023-11-14
Hello,
How do I add commas to numbers using fprintf? My customer wants me to write out tables and have commas in the numbers to better read it. For instance, 123456789.0 would be written out as 123,456,789.0. Thanks.
Best regards,
Bill Rooker

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

采纳的回答

Stephen23
Stephen23 2017-3-8
编辑：Stephen23 2023-9-15
Ran in:
fprintf cannot do that, but you will find several FEX submissions that can create a string with commas as thousands separators:
https://www.mathworks.com/matlabcentral/fileexchange/52832-num2sepstr
https://www.mathworks.com/matlabcentral/fileexchange/41520-insert-commas-into-numbers
If you read the comments to those submissions you will also find several improvements to consider.
Another easy one-line approach:
str = ["1234567890.123456789";"-1234567890";"0"]
str = 3×1 string array
"1234567890.123456789" "-1234567890" "0"
str = regexprep(str,'(?<!\.\d*)\d{1,3}(?=(\d{3})+\>)','$&,')
str = 3×1 string array
"1,234,567,890.123456789" "-1,234,567,890" "0"
  4 个评论
显示 2更早的评论
Stephen23
Stephen23 2023-9-15
编辑：Stephen23 2023-9-15
The only resources I really use are the MATLAB documentation:
https://www.mathworks.com/help/matlab/matlab_prog/regular-expressions.html
https://www.mathworks.com/help/matlab/matlab_prog/dynamic-regular-expressions.html
https://www.mathworks.com/help/matlab/matlab_prog/lookahead-assertions-in-regular-expressions.html
etc.
You can find some online tutorials etc that explain regular expression concepts** but these often are based on Perl or JavaScript or Python or whatever regular expressions (i.e. not the same details) so once you really need to know the details then the only place to look is the MATLAB documentation. Be prepared to read those pages many times.
If you want to experiment then you might find this useful:
https://www.mathworks.com/matlabcentral/fileexchange/48930-interactive-regular-expression-tool
** as well as many websites offering all kinds of automagic things with regular expressions.
Dyuman Joshi
Dyuman Joshi 2023-9-16
I tried working with the documentation pages of regexp() and regexprep(), but haven't been successful with it, as they are not clear/specific enough to me and do not provide sufficient examples to understand the functionality properly.
Thank you very much for the links, I didn't know about these pages, they are what I was looking for!
I have also tried a few online tutorials, but as you mentioned, the functionality of regexp() in other languages are different than in MATLAB.
I will also look into the FEX submission you have link, it does look very extensive, but for now, I will start from the basics with the documentation pages you linked.
Once again, Thank you!

请先登录，再进行评论。

更多回答（4 个）

Ted Shultz
Ted Shultz 2018-6-13
you can do this in two lines. from this page : A simple way is to add this two line function:
function numOut = addComma(numIn)
jf=java.text.DecimalFormat; % comma for thousands, three decimal places
numOut= char(jf.format(numIn)); % omit "char" if you want a string out
end
Hope that helps! --ted
  5 个评论
显示 3更早的评论
Daven Gooden
Daven Gooden 2020-11-10
@Ted Shultz: Spot on! Very clean and easy to understand/use! Thank you very mutch!

请先登录，再进行评论。

Jim Svensson
Jim Svensson 2021-2-15
I feel that in 2021 this functionality should be supported by sprintf/fprintf.
  3 个评论
显示 1更早的评论
Dyuman Joshi
Dyuman Joshi 2023-9-15
@Jim Svensson If you want to have a functionality implemented in MATLAB, you can raise a feature request for it.
https://in.mathworks.com/matlabcentral/answers/460998-how-can-i-make-a-features-request
I believe you will need a strong justification to convince TMW as to why they should implement it.
Image Analyst
Image Analyst 2023-9-16
It would certainly be a convenience if they had a letter to do that conversion, like p or whatever (some unused letter), like
x = 12345678.912345
fprintf('Number = %p.\n', x);
'12,345,678.912'

请先登录，再进行评论。

Image Analyst
Image Analyst 2023-9-15
Ran in:
See my attached utility function that inserts commas to make a string out of a number. Then in your fprintf you print the string with %s instead of %d or %f. For example:
number = 1234567;
fprintf('The number is %s.\n', CommaFormat(number));
The number is 1,234,567.
Toshiaki Takeuchi
Toshiaki Takeuchi 2023-11-14
Ran in:
Using pattern
vec = 123456789;
txt = string(vec);
pat1 = lookBehindBoundary(digitsPattern); % (?<=\d)
pat2 = asManyOfPattern(digitsPattern(3),1); % (\d{3})+
pat3 = lookAheadBoundary(pat2+lineBoundary("end")); % (?=(\d{3})+$)
pat4 = pat1+pat3; % (?<=\d)(?=(\d{3})+$)
replace(txt,pat4,",")
ans = "123,456,789"
  1 个评论
Stephen23
Stephen23 2023-11-14
Ran in:
vec = 1234.56789
vec = 1.2346e+03
txt = string(vec);
pat1 = lookBehindBoundary(digitsPattern); % (?<=\d)
pat2 = asManyOfPattern(digitsPattern(3),1); % (\d{3})+
pat3 = lookAheadBoundary(pat2+lineBoundary("end")); % (?=(\d{3})+$)
pat4 = pat1+pat3; % (?<=\d)(?=(\d{3})+$)
replace(txt,pat4,",")
ans = "1234.5,679"

请先登录，再进行评论。

类别

在 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