How to save data from a file with text and numbers?
4 views (last 30 days)
Show older comments
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
Mathieu NOE
on 15 May 2021
sure
use readlines or fileread
T = fileread('data2.txt');
TT = split(T);
% or
TTT = readlines('data2.txt');
Accepted Answer
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
"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)
See Also
Categories
Find more on String 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!