transfer numerical data end with 'M' and 'B'

1 次查看（过去 30 天）
Yu Li
Yu Li 2024-3-7
编辑： Stephen23 2024-3-7
Hi:
I have a numerical data that is for example, 1234567, I can translate to "%f" and "%e" format using Matlab, but I would like to transfer the data to something like this: 1.23M, where "M" represent "million", simliar if the data is even larger, over billion, I can transfer it as "1.2b".
is it possible to do this is Matlab?
Thanks!
Yu
  4 个评论
显示 2更早的评论
Dyuman Joshi
Dyuman Joshi 2024-3-7
编辑：Dyuman Joshi 2024-3-7
No, there is no official MATLAB command that does that. You will have to write the code for it.
You can utilize the hint that I provided above.
P.S - Isn't the symbol for billion supposed to be B and not b?
Stephen23
Stephen23 2024-3-7
编辑：Stephen23 2024-3-7
Ran in:
As an alternative, you could download and try using my function NUM2WORDS():
https://www.mathworks.com/matlabcentral/fileexchange/47221-number-to-words
It covers the entire DOUBLE range, has many options, and has been extensively tested:
num2words(1234567,'type','highest','sigfig',3)
ans = 'one point two three million'
Note that if you only use the first letter you will have a problem when you reach Quadrillion and Quintillion.
Or you could download my function NUM2SIP():
https://www.mathworks.com/matlabcentral/fileexchange/33174-number-to-scientific-prefix
It provides all of the SI prefixes, and has also been extensively tested:
num2sip(1234567,3)
ans = '1.23 M'

请先登录，再进行评论。

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

回答（1 个）

Chunru
Chunru 2024-3-7
Ran in:
You can define your own function. Here is an example:
sprintfkmb(12345678)
ans = "12.345678M"
sprintfkmb(-12345678)
ans = "-12.345678M"
sprintfkmb(-1238)
ans = "-1.238000k"
sprintfkmb(-1234567890123)
ans = "-1234.567890b"
function s = sprintfkmb(a)
str = ["", "k", "M", "b"];
e = floor(log10(abs(a)));
e3 = floor(e/3);
e3 = min(e3, 3);
s = sprintf("%.6f%s", a/(10^(e3*3)), str(e3+1) );
end

类别

在 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