How I can modify the decimal numbers in a table's column?

78 次查看（过去 30 天）
BN
BN 2021-8-5
评论： Walter Roberson 2023-11-8
I have a table with different values like: 0.5, -0.300, -99, 5, 0, and so on. I want to use the output of this table in a hydrological model so I need to have all values in 1 decimal (even integer values, like 5).
Here is an example:
-5.40000000000000
-2.20000000000000
-3.40000000000000
5
4
-99
0
Are what I have, But I need something like this:
-5.4
-2.2
-3.4
5.0
4.0
-99.0
0.0
I tried something like format long, format long g, and format bank, but they weren't helpful. So if anyone knows the solution I would be grateful if tells me.
Best regards

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

采纳的回答

Chunru
Chunru 2021-8-5
Ran in:
a = randn(5,1)
a = 5×1
0.1370 -0.9759 -1.3119 2.0201 1.3604
str = sprintf('%.1f\n', a)
str =
'0.1 -1.0 -1.3 2.0 1.4 '
  6 个评论
显示 4更早的评论
Walter Roberson
Walter Roberson 2023-11-8
Ran in:
format long g
Column = randn(5,1)
Column = 5×1
-0.474707105013206 1.4443908607698 1.76341706465071 -1.3245954736747 -0.388849281393544
Table = table(Column)
Table = 5×1 table
Column __________________ -0.474707105013206 1.4443908607698 1.76341706465071 -1.3245954736747 -0.388849281393544
Table.Column=round(Table.Column,1)
Table = 5×1 table
Column ______ -0.5 1.4 1.8 -1.3 -0.4
format short
Table
Table = 5×1 table
Column ______ -0.5 1.4 1.8 -1.3 -0.4
Looks to me as if it is working?
Walter Roberson
Walter Roberson 2023-11-8
@Gabor
for exactly 2 decimal places, if you are using uitable() then set the uitable ColumnFormat property to 'bank'
Note that "bank" format rounds numbers. If you happened to be doing financial work then in some cases, floor is prefered to rounding; in such a situation you should use the somewhat-new round TieBreaker option.

请先登录，再进行评论。

更多回答（1 个）

Awais Saeed
Awais Saeed 2021-8-5
You want to display the numbers as shown or modify them? In case you want to modify them, you can use
number = -99.32345; % the number you want to modify
num_str = num2str(number); % convert it to string
[idx,~]=regexp(num_str,'[.]'); % search for decimal point
num_str(idx+2:end) = []; % delete everything from idx+2 till end
number = str2num(num_str) % convert result back to number
You can use this in a loop to modify all of your values.

类别

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

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by