moving a value under a certain value
Info
This question is closed. Reopen it to edit or answer.
Show older comments
A have a structure with a cell aray called textdata. The cells in column 2 are filled with the words abc or efg. In the case a cell of this column contains efg, I like to replace the value from column 3 (same row) with the value of column 4. How can I do that? Thank you
8 Comments
KSSV
on 7 Apr 2018
Attach your data..
Erik Verdijk
on 7 Apr 2018
Erik Verdijk
on 9 Apr 2018
KSSV
on 9 Apr 2018
Attach the excel sheet...not image snippet....
Walter Roberson
on 9 Apr 2018
How are you reading it in? Are you looking at the raw data?
Erik Verdijk
on 9 Apr 2018
Walter Roberson
on 9 Apr 2018
zip the file and attach the zip
Erik Verdijk
on 9 Apr 2018
Answers (1)
Walter Roberson
on 9 Apr 2018
mask = strcmp(raw(:,2), 'efg');
raw(mask, 3) = raw(mask, 4);
This question is closed.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!