How to remove a pattern in a table column

Question

JFz 2016-10-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305741-how-to-remove-a-pattern-in-a-table-column

评论： JFz 2016-10-4

Hi,

I have a table with a column. The column looks like this: 'AB_Off' 'ABC' 'CDE_Off'

I would like to remove the '_Off' from every cell in that column. I tried TF = endsWith, and match, but I always get error. "Error using string string is obsolete and will be discontinued. Use char instead." I don't know how to resolve this. Would you please help? Thanks,

Jennifer

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Jan Orwat 2016-10-4

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305741-how-to-remove-a-pattern-in-a-table-column#answer_237356

编辑：Jan Orwat 2016-10-4

在 MATLAB Online 中打开

assuming T - your table, and n - number of column containing these strings you can do as follows:

T{:, n} = regexprep(T{:, n}, '_Off$', '');

or

T{:, n} = erase(T{:, n}, '_Off');

but second option doesn't detect if it's on the end of a string

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

JFz 2016-10-4

Thank you!

请先登录，再进行评论。

Answer 2

Hamid Ebrahimi Orimi 2016-10-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305741-how-to-remove-a-pattern-in-a-table-column#answer_237350

you mean you have a cell which has 'ABC_Off' string in each element? If I understood correctly, the answer is as follow: A={'ABC_Off', 'ABC_Off','ABC_Off'} for i=1:length(A) if A{i}=='ABC_Off' A{i}='ABC'; end end A is your defined cell.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 3

elias GR 2016-10-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305741-how-to-remove-a-pattern-in-a-table-column#answer_237353

编辑：elias GR 2016-10-4

在 MATLAB Online 中打开

strfind function is what you need ( https://www.mathworks.com/help/matlab/ref/strfind.html ). I suppose that you have a cell array of string. Then a simple general solution to remove the _Off from the end of the strings (we suppose that _Off only occurs at the end) is:

str={'AB_Off','ABC','CDE_Off'};
for i=1:length(str)
    ind=strfind(str{i},'_Off');
    if ~isempty(ind)
        str{i}=str{i}(1:ind-1);
    end
end

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

JFz 2016-10-4

Thanks a lot.

What I have is a column in a Matlab table. the 'AB_Off', 'ABC', 'CDE_Off' are on different rows in that same column. Is there a way to make all the '_Off' in that column go away? Thanks,

Jennifer

请先登录，再进行评论。