Compare text to a column value and write corresponding row to new file
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Joseph Corry
le 15 Mar 2021
Commenté : ANKUR KUMAR
le 16 Mar 2021
I need to write a code that will read every value in a matrix colum (about 5,000 entries long), compare the value in each cell to an existing variable and if the cell value matches the existing variable, write the entire row to a new table.
I am thinking I will need to use a 'for' loop to evaluate the entire matrix and string compare but I am not sure how to go about writing this.
0 commentaires
Réponse acceptée
ANKUR KUMAR
le 15 Mar 2021
You can find the indices of matching values in matrix and cell.
matrix=randi(10,1,100);
cell_existing_variable=num2cell(randi(10,1,100),1);
find(matrix==cell2mat(cell_existing_variable))
If this helps you, its good. Otherwise, I would request you to attach mat file having sufficient varibales.
8 commentaires
ANKUR KUMAR
le 16 Mar 2021
I doubt whether xlswrite works in online app or not. xlswrite is working well in MATLAB2017b (which I am using). @MathWorks Support Team
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!