MATLAB Answers

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

3 views (last 30 days)
BN
BN on 5 Aug 2021
Answered: Awais Saeed on 5 Aug 2021
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

Accepted Answer

Chunru
Chunru on 5 Aug 2021
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 '

More Answers (1)

Awais Saeed
Awais Saeed on 5 Aug 2021
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.

Products


Release

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by