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

Question

Yu Li 2024-3-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2091476-transfer-numerical-data-end-with-m-and-b

编辑： 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更早的评论隐藏 2更早的评论

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 2024-3-7

编辑：Stephen23 2024-3-7

在 MATLAB Online 中打开

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'

请先登录，再进行评论。

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

Answer 1

Chunru 2024-3-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2091476-transfer-numerical-data-end-with-m-and-b#answer_1422211

在 MATLAB Online 中打开

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