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 commentaires

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

Réponses (1)

Walter Roberson
Walter Roberson le 9 Avr 2018
mask = strcmp(raw(:,2), 'efg');
raw(mask, 3) = raw(mask, 4);

Cette question est clôturée.

Clôturé :

le 20 Août 2021

Community Treasure Hunt

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

Start Hunting!

Translated by