Find all rows that contain a specific value in a excel

6 Ansichten (letzte 30 Tage)
Cristian Martin
Cristian Martin am 28 Mai 2022
Kommentiert: Voss am 28 Mai 2022
I vave an edit text an a push button for search all rows that contain a specific value in a column
T = readtable('prices.xlsx');
item = get(handles.edit1,'String');
FinalTable = T(strcmp(T.Product, 'String', item),:);
Where is my mistake?
Error using strcmp
Too many input arguments.
If instead of using get from edit1 and use:
T = readtable('prices.xlsx');
%item = get(handles.edit1,'String');
FinalTable = T(strcmp(T.Product, 'Corn'),:);
is working

Akzeptierte Antwort

Voss
Voss am 28 Mai 2022
This call to strcmp:
strcmp(T.Product, 'String', item)
has an extraneous 2nd argument 'String'. It should be:
strcmp(T.Product, item)
This way, you'll notice, it conforms to the code that works, with 'Corn' being replaced by item.

Weitere Antworten (0)

Kategorien

Mehr zu Cell Arrays finden Sie in Help Center und File Exchange

Produkte


Version

R2015a

Community Treasure Hunt

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

Start Hunting!

Translated by