How do I remove unwanted strings from a table imported from excel?
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
I read an excel table that contains 5 columns of values and 1 column of string. I want to remove some text from the string column such that if the text stands all alone on a line, the entire row is deleted.Please, see the attached file.
In the worksheet, I want to remove "<Thread>", "<ThreadID>289123_4_3</ThreadID>","<InitPost>" etc.
0 comentarios
Respuestas (1)
Image Analyst
el 25 de Feb. de 2014
Attach the workbook and your calls to readtable() . If you don't have the latest MATLAB and are having to use xlsread() instead, then let us see your code, or else upgrade where this will be a lot easier.
4 comentarios
Ver también
Categorías
Más información sobre Spreadsheets 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!