清空筛选条件
清空筛选条件

fprintf not writing same information from command window

3 次查看（过去 30 天）
Anna Cole
Anna Cole 2018-6-14
编辑： Jonathon Gibson 2018-6-14
I want to create two columns. The first column has numbers 1 through 10 from f. The second column has zeros from b, but in certain positions contained in a there needs to be values. Some of the values are duplicates so that is taken care of with the accumarray. I need the zeros to be in the format 0.0 and the numbers have 9 decimal places. When I type out in the command window it had the correct numbers in the correct places but the zeros and number formats are incorrect, but in the xlsreadtrial.txt file it doesn't look correct.
b=zeros(10,1);
% writes zeros
a = xlsread('trial.xlsx','Sheet2','A1:B4');
% reads values from excel
f = (1:1:10)';
% first column values
h=a(:,1);
% breaks a into first column only
n=a(:,2);
% breaks a into second column only
k=[f;h];
% adds first column of a onto the end of f
m=[b;n];
% adds second column of a onto the end of b
p=[k,m];
% combines first and second columns
c = 9 * ones(length(p),1);
c(b==0) = 1;
out=[unique(p(:,1)) accumarray(p(:,1),p(:,2))];
% makes first column values unique and accounts for duplicates
fileID = fopen('xlsreadtrial.txt','w');
fprintf(fileID,'%d,%.f\n',out');
fclose(fileID);
  4 个评论
显示 2更早的评论
Anna Cole
Anna Cole 2018-6-14
%g now displays the correct numbers in the txt file output but I want to have a variable number of decimal places so the output looks like this:
1,0.368945
2,0.0
3,0.598765
4,0.0
5,0.500000
6,0.0
7,0.0
8,0.0
9,0.0
10,0.0

请先登录，再进行评论。

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

回答（1 个）

Jonathon Gibson
Jonathon Gibson 2018-6-14
编辑：Jonathon Gibson 2018-6-14
If you want different formatting depending on the row, you can print each row individually:
fileID = fopen('xlsreadtrial.txt','w');
for row = out'
if row(2) == 0
fprintf(fileID,'%d,%.1f\n',row);
else
fprintf(fileID,'%d,%.9f\n',row);
end
end
fclose(fileID);
Which gives you 9 decimal places if the second column is not equal to 0 and just 1 decimal place for the 0s.
1,0.368945000
2,0.0
3,0.598764523
4,0.0
5,0.500000000
6,0.0
7,0.0
8,0.0
9,0.0
10,0.0

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by