Compare text to a column value and write corresponding row to new file
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
ANKUR KUMAR
2021-3-15
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 个评论
ANKUR KUMAR
2021-3-16
I doubt whether xlswrite works in online app or not. xlswrite is working well in MATLAB2017b (which I am using). @MathWorks Support Team
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!