how would i split a table based on a portion of a keyword
5 次查看(过去 30 天)
显示 更早的评论
I have a table that has a many cols, however the data is from different product range. I generally what to sort it into two tables based on one cols containing a specific word that is common to the data, but there are other words and int's in the cell as well. How do i isolate these words to sort them, the position of the key word is not static, or a fixed character away from the start?
If that makes sense?
0 个评论
采纳的回答
Xavier
2020-9-9
Something like this may work, but it depends on how your data is structured in the table- if you can provide more information I can update my answer
table_one = main_table(contains(main_table.yourColumn, "key text"), :);
table_two = main_table(~contains(main_table.yourColumn, "key text"), :);
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Cell Arrays 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!