read a text file
3 views (last 30 days)
Show older comments
Postit123
on 4 Nov 2020
Answered: Pratheek Punchathody
on 18 Nov 2020
Hi
I need to make a matrix with the text file attached below.
I've considered 'fscanf' and 'readtable'.
But I faced 2 problems.
Some of rows have 8 elements while others have 10.
Also, there are blank cells and I don't know how to handle this to make it 0.
Thanks.
1 Comment
Walter Roberson
on 4 Nov 2020
See https://www.mathworks.com/help/matlab/ref/matlab.io.text.fixedwidthimportoptions.html
Accepted Answer
Pratheek Punchathody
on 18 Nov 2020
As per my understanding it is required to create a matrix/table from the data present in the text file.
For the demo purpose I have taken the sample text file which has different number of columns in each row and there are multiple empty cells in each row.
Considering the sample text file with the data as shown below.
Below is the code I have used to import the text file to a matrix.
opts = detectImportOptions('same.txt', 'EmptyLineRule','skip','ExtraColumnsRule','ignore');
opts.MissingRule = 'fill';
opts = setvaropts(opts,'FillValue',0); %fill the empty cells with the value 0
myTable = readtable('same.txt',opts); %create table from the .txt file
myMatrix=table2array(myTable); %create from the table
Below image shows the output matrix of the data present in the text file.
“table2array()” function is used to convert the created table to matrix format.
As required, all the empty cells adn extra column cells are filled with 0.
0 Comments
More Answers (0)
See Also
Categories
Find more on Migrate GUIDE Apps 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!