how would i split a table based on a portion of a keyword
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Mark Peeters
am 9 Sep. 2020
Kommentiert: Xavier
am 9 Sep. 2020
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 Kommentare
Akzeptierte Antwort
Xavier
am 9 Sep. 2020
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"), :);
2 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Text Data Preparation finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!