How to parse (extract) data from a text file?

10 views (last 30 days)
Razvan Bataiosu
Razvan Bataiosu on 12 Mar 2019
Edited: Jan on 12 Mar 2019
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!
AnalyzedFile.JPG
  4 Comments
Razvan Bataiosu
Razvan Bataiosu on 12 Mar 2019
The lines of interest can be identified by “CANFD” string and I would like to obtain them ideally in binary format. I have tried firstly to make a filter to take the values after the string “canfd” and then put them in cells, by each row, but I don’t know if that is the roght approach. Thank you!
Jan
Jan on 12 Mar 2019
Edited: Jan 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.

Sign in to comment.

Answers (1)

Jan
Jan on 12 Mar 2019
Edited: Jan on 12 Mar 2019
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!