Clear Filters
Clear Filters

Info

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

reading a text file data

1 view (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)

This question is closed.

Community Treasure Hunt

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

Start Hunting!