How do I remove unwanted strings from a table imported from excel?
3 views (last 30 days)
Show older comments
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 Comments
Answers (1)
Image Analyst
on 25 Feb 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 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!