How do I remove unwanted strings from a table imported from excel?
조회 수: 3 (최근 30일)
이전 댓글 표시
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
답변 (1개)
Image Analyst
2014년 2월 25일
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
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!