moving a value under a certain value

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

Attach your data..
I made an example in excel.
Can someone help me please? dónt want´to be rude.
Attach the excel sheet...not image snippet....
How are you reading it in? Are you looking at the raw data?
Excel file format is not allowed
zip the file and attach the zip

Answers (1)

mask = strcmp(raw(:,2), 'efg');
raw(mask, 3) = raw(mask, 4);

This question is closed.

Asked:

on 7 Apr 2018

Closed:

on 20 Aug 2021

Community Treasure Hunt

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

Start Hunting!