Info

This question is closed. Reopen it to edit or answer.

reading a text file data

2 views (last 30 days)
KRISHNA NISHCAL BHARATULA
KRISHNA NISHCAL BHARATULA on 26 Sep 2019
Closed: MATLAB Answer Bot on 20 Aug 2021
hello all!, I have a text file and I used 'dlmread' command to read the data, and had the following results:
well = [0 1 2 3 4 0 0;0 5 6 0 0 8 11;0 11 12 0 0 55 49;0 2 88 44 26 0 0;0 8 96 7 4 0 0;0 22 6 41 20 0 0;0 63 5 0 0 11 4; 0 52 8 0 0 63 32];
the above is just a sample format, actually i have a data containing 6511 rows and in between I am seeing this behaviour. I removed the first column of zeros; for which i used this:
well(:,~any(well,1)) = [];
Now, i want to shift those miss-arranged data in appropriate columns and produce result in following manner for the rows (out of 6511) wherever applicable:
result = [1 2 3 4 ;5 6 8 11;11 12 55 49;2 88 44 26;8 96 7 4;22 6 41 20;63 5 11 4;52 8 63 32];
Thank you!
  2 Comments
Walter Roberson
Walter Roberson on 26 Sep 2019
I wonder if reading with readtable() might not have done a better job for you ?
KRISHNA NISHCAL BHARATULA
KRISHNA NISHCAL BHARATULA on 26 Sep 2019
Thank you Walter! You gave me a wonderful hint and for my next problem as well.

Answers (0)

Community Treasure Hunt

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

Start Hunting!