MATLAB Answers

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

2 views (last 30 days)
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?

  7 Comments

Show 4 older comments
Image Analyst
Image Analyst on 5 Jul 2020
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
huazai2020 on 5 Jul 2020
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
Walter Roberson on 5 Jul 2020
Take my code and use writematrix or xlswrite to write the data variable to an xlsx file.

Sign in to comment.

Accepted Answer

Stephen Cobeldick
Stephen Cobeldick on 6 Jul 2020
>> 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

  0 Comments

Sign in to comment.

More Answers (1)

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

  7 Comments

Show 4 older comments
huazai2020
huazai2020 on 8 Jul 2020
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
Walter Roberson on 8 Jul 2020
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.

Sign in to comment.

Tags


Translated by