Why I the data processed by the matlab is wrong, it reports three wrong results,what is the reason?All the data and .m files are included ,who can help me?

Why I the data processed by the matlab is wrong, it reports three wrong results,what is the reason?All the data and .m files are included ,who can help me?

[huazai2020]

 i=9;
%i表示序号为i的文件
if i<10
    fileindex=strcat('00',int2str(i));
elseif i>9 && i<100
    fileindex=strcat('0',int2str(i));
end
filename=strcat('tem-',fileindex);%%%%需要根据实际out文件数据名
%%更改‘phase-line-’，但名称需要改为phase-line-001.out，phase-line-002.out
filename=strcat(filename,'.out');
%将与数字关联的文件名储存在fileindex中
if exist(filename, 'file')==0
    continue
end
%判断文件是否存在
filec=importdata(filename);
data=filec.data;
%加载第i个文件
if i==9
NUM=data(:,1);
NUMcap=[9;NUM];
xlswrite('thickness.xlsx',NUMcap,'sheet1','J');
end

[Image Analyst]

There is no .out file in your zip file.

[huazai2020]

These is the .out file, please check it. Thank you for your help.

[darova]

Don't understand the question. Everything looks correct

[huazai2020]

You see the yellow word， the left are the primary data，the right are the process data， you see they are different, what is the reason?

Answer 1

[Image Analyst]

The display looks a little different but that's probably just due to the third column not being wide enough to show the same number of digits. Grab the divider line between the columns and widen it. It should look the same after that.

[huazai2020]

No， the value are not the same， the left is 0.58（Decimal）， the right is 58469706（interger）， they cannot be the same.You can use my data to have a try, you can find my problem.

Answer 2

[Fangjun Jiang]

This is probably the limitation of the smartness of the importdata() function.

If you look at filec.textdata, you will get a clue. It tries to separate the data based on 'line-10'. 'line-10' is read in correctly. All the lines below, either the digit "0" or "0." are treated and included in as the text data.

So for 'line-20', "0" is truncated but ".5474641" is still read in as "0.5474641"

for "line-30', "0." is truncated thus "59778373" is read in as "59778373"

For your input file text format, it's better to use textscan(), although it can't be done with one line of code.

For this particular file "'tem-009.out'", I tried A=readmatrix(filename,'filetype','text') and it does give correct result.

[huazai2020]

Could you show me the whole code for me, thank you so much.

[Fangjun Jiang]

It's in your code. filec=importdata('tem-009.out'); filec.textdata

[huazai2020]

I have tried it as you said , but it has the same results.

i=9;

%i表示序号为i的文件

if i<10

fileindex=strcat('00',int2str(i));

elseif i>9 && i<100

fileindex=strcat('0',int2str(i));

end

filename=strcat('tem-',fileindex);%%%%需要根据实际out文件数据名

%%更改‘phase-line-’，但名称需要改为phase-line-001.out，phase-line-002.out

filename=strcat(filename,'.out');

%将与数字关联的文件名储存在fileindex中

if exist(filename, 'file')==0

continue

end

%判断文件是否存在

filec=importdata('tem-009.out');

data=filec.data;

%加载第i个文件

if i==9

NUM=data(:,1);

NUMcap=[9;NUM];

xlswrite('thickness.xlsx',NUMcap,'sheet1','J');

end

[Fangjun Jiang]

Read my answer again. I am trying to explain to you why importdata() caused the problem. And there is a suggestion to use textscan() but will require more lines of code. You could try readmatrix(). It doesn't have this problem. You could use it if you can process the data towards what you want.

[huazai2020]

Thank you, I am not familar with matlab,could you show me the code directly?

[Fangjun Jiang]

In your original code, replace these two lines of code

filec=importdata(filename);
data=filec.data;

with

filec=readmatrix(filename,'FileType','text');
data=filec(1:end-2,2);

That is all!

[huazai2020]

Thank you . First I know the one line data input, it is as following:

filec=importdata('tem-009.out');
data=filec.data;

But when it comes to two data input, it is not right, the codes is below:

clc;clear all;
filec=readmatrix(tem-,'FileType','text');
data=filec(1:end-2,2);

the error is below :

filec=readmatrix(tem-,'FileType','text');

|

Error: Expression or statement is incorrect--possibly unbalanced (, {, or [.

Could you tell me why？

[Walter Roberson]

filec=readmatrix(tem-,'FileType','text');

tem- is not a file name: it is a request to subtract something unspecified from a variable named tem

filec=readmatrix('tem-009.out','FileType','text');
data=filec(1:end-2,2);

[huazai2020]

I use your code, but it has the following error:

Undefined function 'readmatrix' for input arguments of type 'char'..My matlab is R2012b, how could I solve it ?

In addition, if I have more than one data, such I have "tem-010.out", how to read it at the same time?

[Image Analyst]

"how could I solve it ?" - the very best way is to upgrade to r2020a. Other than that you can try another function like importdata() or csvread() or dlmread().

[huazai2020]

Can I updata it directly to r2020a, or I should download a new one and setup it again.

What is the difference of importdata() or csvread() or dlmread()? Thank you.

[Image Analyst]

csvread() reads only comma separated values. dlmread() can have other delimiters in addition to commas. importdata() tries to be a smarter function than either of those two in that the data can be more complicated and it will try to figure it out.

Answer 3

[Stephen23]

opt = {'CollectOutput',true };
[fid,msg] = fopen('tem-009.out','rt');
assert(fid>=3,msg)
str = '';
while ~strncmp(str,'-',1)
    str = fgetl(fid);
end
C = textscan(fid,'line-%f%f',opt{:});
fclose(fid);
M = C{1};

Giving:

>> M
M =
   10.0000    0.7539
   20.0000    0.5475
   30.0000    0.5978
   50.0000    0.3828
   70.0000    0.5847
   90.0000    0.1664
  110.0000    0.2465
  130.0000    0.5116
  150.0000    0.3211
  160.0000    0.3744
  170.0000    0.6611

[huazai2020]

Thank you, if I have more than one .out, how can I put them in one data file?

[Stephen23]

import them file data:

https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

and then concatenate and save.

[huazai2020]

Thank you， I have use as the code below：

clc;clear all;
numfiles = 1;
mydata = cell(1, numfiles);
for k = 1:numfiles
  myfilename = sprintf('tem-009.out', k);
  mydata{k} = importdata(myfilename);
end

But it does not give any data for me ， can you help me？

[Stephen23]

@huazai2020: My answer does not use importdata. My code works: I tested it on your example file and showed the imported data in my answer. Have you tried it?

Your code uses importdata and is unrelated to my answer. importdata does not work.

I have already provided you with a working solution to import that file. What else do you expect me to do?

[huazai2020]

The code can run， but the data result is not right as you can see the attached image.I have attached the data, would you please share me the code directly?Thank you.

[Stephen23]

"would you please share me the code directly?"

Sure, I already did that by writing and testing code that uses textscan. You can see that working code in my answer.

You showed in your earlier comment that you are using some code that is totally unrelated to my answer.

[huazai2020]

But you told me use the following link (https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html) to concatenate and save, there has the importdata function. If I have more than one data, how could I import together ?

[huazai2020]

In addition, I only want the second colum of the data, how could I do it?

[huazai2020]

Finally, I have another different type data(see tem-001.txt), I could not use your former code to imput it, how to deal with it ?

[Stephen23]

"but you told me use the following link (https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html) to concatenate and save, there has the importdata function."

The documentation shows importdata for one of the two examples, the other example uses imread. Of course you can trivially adapt both of those examples to use any file importing function (MATLAB has many) that you want (or to use any code that you write yourself or that you get given).

Those examples just show the approach, they do not mean that you can only use importdata or imread. That is how all programming languages work: the documentation does not show every permutation of options because that would be too many, instead they show some examples and rely on the user to generalize that knowledge to other use cases.

"In addition, I only want the second colum of the data, how could I do it?"

Either use indexing after importing or change the format string to

'line-%*f%f'

How to specify the format string is explained in the textscan documentation.

"I have another different type data(see tem-001.txt), I could not use your former code to imput it, how to deal with it ?"

Of course not, it has a totally different format. A regular expression would be one simple approach.

[Fangjun Jiang]

Three or four MVPs have been around here going around a circle. Sometimes you got to know when to give up.

[huazai2020]

Hi,Stephen, but how could solve the problem about the tem-001.txt

[Stephen23]

https://www.mathworks.com/matlabcentral/answers/559526-who-could-get-all-the-data-in-the-attached-file-by-the-matlab#answer_461735