How to parse (extract) data from a text file?
Show older comments
Hello! I have the following text file and I want to extract the data marked with red pen. The file has a lot of rows like this, but, the position of the desired data is generally the same. I have tried a few things as in the attached file, but it doesn't seem to work. Any ideas?
Thanks!

4 Comments
Adam
on 12 Mar 2019
What does the 'bull at a gate' approach of just calling
doc importdata
give you?
It is surprisingly good at reading data in a variety of formats and managing to put the data into servicable structures within Matlab.
Jan
on 12 Mar 2019
"It doesn't seem to work" is a weak description of the occurring problems. You did not define exactly, what you want to extract. Are these specific line numbers or can the lines be identified by the "CANFD" string? In which format do you want to obtain the data? As cell string or by hex2dec?
Razvan Bataiosu
on 12 Mar 2019
What exactly is "binary format?" This is not clear for the string
1 0 b 20 61 ...
Please be as sepcific as possible: What is the wanted output for the shown input?
It would be easier to write questions, if you provide the file as text and not as screenshot.
Answers (1)
Str = fileread(FileName);
CStr = strsplit(Str, char(10));
match = contains(CStr, 'CANFD');
Data = CStr(match);
Data contains the wanted lines now, but it is not clear to me, what you want as output.
Categories
Find more on Text Data Preparation in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!