How to save data from a file with text and numbers?

5 views (last 30 days)
Abhiram B R
Abhiram B R on 14 May 2021
Edited: per isakson on 16 May 2021
I have to load a file to Matlab with words and numbers and perform few operations. Structure of the file to be loaded is as follows:
Step
0
Number
1000
Box Dimension
0 10 0
10 0 0
0 0 10
ID Type
1 2
2 3
3 1
.....
i need to load this file and save lines starting from 'Step' to 'ID Type' to another file. Is it possible to do such operations in MATLAB?
  2 Comments

Sign in to comment.

Accepted Answer

per isakson
per isakson on 15 May 2021
Edited: per isakson on 16 May 2021
"load this file and save lines starting from 'Step' to 'ID Type' to another file" Including the "ID Type" block - or not ?
This script includes the "ID Type" block. I assume that the sample data is followed by a specific word. I've replaced the ending "...." with the string "Something else".
%%
chr = fileread( 'Untitled3.txt' );
txt = regexp( chr, '^.+(?=Something else)', 'match','once' );
fid = fopen( 'another_file.txt', 'wt' );
fprintf( fid, '%s', txt );
fclose( fid );
type another_file.txt
Step 0 Number 1000 Box Dimension 0 10 0 10 0 0 0 0 10 ID Type 1 2 2 3 3 1
"and perform few operations" In what form do you want which data?
Second thought:
The function, regexp(), is powerful and fast but not the easiest to get the hang of. In this case the statement
txt = regexp( chr, '^.+(?=Something else)', 'match','once' );
can be replaced by
pos = strfind( chr, 'Something else' );
txt = chr(1:pos(1)); % pos(1) in case there are many 'Something else' in the file
or
txt = extractBefore( chr, 'Something else' );
I should have used extractBefore() in my answer. It's easy to use and fast.

More Answers (0)

Products


Release

R2021a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!