MATLAB: Finding the row and column in a cell array!

cell arrayfind

Hey everybody,

a={'Mk1326=Scanner,Scan'; 'Mk1327=Scanner,Scan';'Mk1328=Scan';'0,26685,1,0';'Mk1329=SyncStatus,Sync';'Mk1330=Scanner,Scan'};

How can I extract the row and column that only contains 'Scanner' in it?

Thanks in advance, Mehdi

Best Answer

a={'Mk1326=Scanner,Scan'; 'Mk1327=Scanner,Scan';'Mk1328=Scan';'0,26685,1,0';'Mk1329=SyncStatus,Sync';}
out = a(~cellfun('isempty',regexp(a,'Scanner')))

Related Solutions

MATLAB: How to use R2020a import tool to upload multiple excel files

Yes. Is the format of your data the same in all your files? If yes, then use the import tool to generate a function instead of a script. That function can be used to automate the import process of all files with the same formatting. It appears you are already familiar with the Import Tool. If you do want to create an importing function, this video shows you how to generate and reuse your code.

And if you have a lot of files, this video shows you how to use the import function you have created in conjunction with a datastore to import multiple files.

I'd suggest reading your data in as a table instead of a cell array. This short video shows how to access data in a table.

MATLAB: List all cells that match logical criteria

>> C = {1,'13_dogs';[],'24_dogs';1,'100_dogs';[],'7_dogs'};
>> X = cellfun(@(a)isequal(a,1),C(:,1));
>> D = C(X,2);

Checking:

>> D{:}
ans = 13_dogs
ans = 100_dogs

Best Answer

Related Solutions

MATLAB: How to use R2020a import tool to upload multiple excel files

MATLAB: List all cells that match logical criteria

Related Question