How do I remove unwanted strings from a table imported from excel?

Question

Adekunle Obasa 2014-2-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/119043-how-do-i-remove-unwanted-strings-from-a-table-imported-from-excel

评论： Image Analyst 2014-2-28

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Image Analyst 2014-2-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/119043-how-do-i-remove-unwanted-strings-from-a-table-imported-from-excel#answer_126100

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 个评论
显示 2更早的评论隐藏 2更早的评论

Adekunle Obasa 2014-2-27

在 MATLAB Online 中打开

   clear
[header, y, x]=xlsread('sent_training_sample.xlsx', 1, 'A2:F1806');
for i=1:size(x,1)  %row length
s1=x(i,:); % to assign a complete row to s1 
c1=s1(:,6); % to assign col. 6 of s1 to c1
e=['<Thread>', '<ThreadID>', '</ThreadID>', '<InitPost>', '<UserID>', '</UserID>', '<Date>', '</Date>', '</InitPost>', '<Post>', '</Post>'];
% e is the list of all tags that are to be removed from text.
b=regexp(c1, '(<)\w*(>)|(</)\w*(>)$', 'match') %regex to extract xml tags
a=unique(ismember(b,e)) 
if a==0
    xlswrite('tag_free', s1,'free');
end
end

b =

{1x1 cell}

Error using cell/ismember>cellismemberlegacy (line 131) Input A of class cell and input B of class char must be cell arrays of strings, unless one is a string.

Error in cell/ismember (line 76) [varargout{1:nlhs}] = cellismemberlegacy(varargin{:});

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% The problem with the code is that the value of "b" as generated by the regular expression could not be passed into "a=unique(ismember(b,e))". It appears there is type mismatch. Please kindly help out!