Find and trim text in a table

Question

Bryan Wilson 2017-12-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/371231-find-and-trim-text-in-a-table

回答： Peter Perkins 2017-12-19

I have a table with a column of strings. In each string, I need to find the '_' character and trim off it and all text to the right. My brain has stopped working and can't figure it out. Thanks!

T = table({"A_1";"A_2";"A_10"},[1;2;1],[6;7;5],...
    'VariableNames',{'Section' 'Data1' 'Data2'})
T =
    Section    Data1    Data2 
    _______    _____    _____
    "A_1"      1        6    
    "AB_2"     2        7    
    "B_10"     1        5

What I'd like is....T=

    Section    Data1    Data2
    _______    _____    _____
    "A"        1        6    
    "AB"       2        7    
    "B"        1        5

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

请先登录，再进行评论。

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

Answer 1

KL 2017-12-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/371231-find-and-trim-text-in-a-table#answer_294820

编辑：KL 2017-12-5

在 MATLAB Online 中打开

use regexprep,

 T = table({"A_1";"AB_2";"B_10"},[1;2;1],[6;7;5],...
    'VariableNames',{'Section' 'Data1' 'Data2'});
 T.Section = cellfun(@(x) regexprep(x,'(?=\_)[\S]*',''),T.Section,'uni',0)
 T =
  3×3 table
    Section    Data1    Data2
    _______    _____    _____
    ["A" ]     1        6    
    ["AB"]     2        7    
    ["B" ]     1        5

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

Bryan Wilson 2017-12-5

Thank you! As a side note, the regexprep didn't work on my string data, but was just find after a cellstr conversion.

请先登录，再进行评论。

Answer 2

Peter Perkins 2017-12-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/371231-find-and-trim-text-in-a-table#answer_296855

在 MATLAB Online 中打开

As KL's answer indicated, this isn't really a question about tables, you just need to figure out how to do it for a string column vector, and then put "T." in from of the string variable's name.

If you have strings data, not a cellstr, take a look at extractBefore. I think it does exactly what you're looking for. And

methods string

will lead you to a bunch of other related operations.