how would i split a table based on a portion of a keyword
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Mark Peeters
el 9 de Sept. de 2020
Comentada: Xavier
el 9 de Sept. de 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 comentarios
Respuesta aceptada
Xavier
el 9 de Sept. de 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 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Text Data Preparation en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!