Who could get all the data in the attached file by the matlab?

Who could get all the data in the attached file by the matlab? I do not need the text words, but only need the data in two column?Who can help me?

[dpb]

>> unzip tem-001.zip
Error using unzip (line 84)
Invalid zip file "C:\Users\Duane\...\Work\tem-001.zip". 
>> 

Now what?

Just attach a short section of the text file as text...

What did you try? Sounds like readtable would likely work but will depend on just what the format of the file is...

[huazai2020]

I have uploaded the data again， please check whether you can open it？

[Walter Roberson]

MATLAB's unzip, and the default Mac unzip had problems with the .zip file, but the product iZip had no problem with it.

[huazai2020]

OK,Could you help me deal with the data?

[Image Analyst]

Are you saying that Walter's solution below did not work to import the data??? Because I just tried it, and it worked. Or are you saying you have no idea what to do with your data? Please explain exactly what "deal with" means.

[huazai2020]

It is not Walter's problem, but my data "tem-001.txt", could you import it into one xlsx.file? If yes, could you send me the code, thank you.

[Walter Roberson]

Take my code and use writematrix or xlswrite to write the data variable to an xlsx file.

Answer 1

[Stephen23]

>> rgx = '([-+]?\d+\.?\d*([eE][-+]?\d+)?)';
>> str = fileread('tem-001.txt');
>> tkn = regexp(str,[rgx,'\s+',rgx],'tokens');
>> mat = str2double(vertcat(tkn{:}))
mat =
     0.025788    0.0045471
     0.016141    0.0093192
    0.0088788     0.010581
    0.0040584      0.01115
  -1.2949e-12       0.0112
   -0.0040227     0.011052
   -0.0090357     0.010768
    -0.015782     0.009112
    -0.025416    0.0044815

Answer 2

[Walter Roberson]

filename = 'tem-001.txt';
S = fileread(filename);
SS = strjoin( regexp(S, '^\s*-?\d.*$', 'match', 'lineanchors', 'dotexceptnewline'), '\n');
data = cell2mat(textscan(SS, '%f%f'));

[huazai2020]

It gives the below errors when I use your codes:

filename = 'tem-001.out';
S = fileread(filename);
SS = strjoin( regexp(S, '^\s*-?\d.*$', 'match', 'lineanchors', 'dotexceptnewline'), '\n');
data = cell2mat(textscan(SS, '%f%f'));

Undefined function 'strjoin' for input arguments of type 'cell'.

[Walter Roberson]

Which MATLAB release are you using? strjoin() was added in R2013a.

[huazai2020]

R2012B

[Walter Roberson]

filename = 'tem-001.out';
S = fileread(filename);
S = regexp(S, '^\s*-?\d.*$', 'match', 'lineanchors', 'dotexceptnewline');
SS = S{1};
CR = sprintf('\n');
for K = 2 : numel(S)
    SS = [SS, CR, S{K}];
end
data = cell2mat(textscan(SS, '%f%f'));

[huazai2020]

Thank you， it works

[huazai2020]

Could you tell me the meaning of each row？ What is the difference between below？

>> rgx = '([-+]?\d+\.?\d*([eE][-+]?\d+)?)';

>> str = fileread('tem-001.txt');

>> tkn = regexp(str,[rgx,'\s+',rgx],'tokens');

>> mat = str2double(vertcat(tkn{:}))

[Walter Roberson]

That is Stephen's code.

rgx is assigned a pattern that will match floating point numbers with optional decimal place and optional exponent. However the pattern misses the possibility of a decimal number with no leading digits before the period.

The assignment to str reads the content of the file all at once and puts it into the variable.

The next line creates a pattern of one number representation followed by whitespace followed by another number representation. Then it searches the content of the file returning the characters that match the patterns.

The matched parts are put together into columns and passed to str2double to convert to numeric.

The workings of patterns for regular expressions is too large a topic for now. There is a file exchange contribution that helps explore regular expressions. The finer points of regular expressions can be pretty tricky.