Need to Split a column of type 'string' in a Table in to group of 4 characters giving new names to the result.

Question

manoj hanu 2019-8-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/475714-need-to-split-a-column-of-type-string-in-a-table-in-to-group-of-4-characters-giving-new-names-to-t

评论： manoj hanu 2019-8-15

I have read a csv file in to a table in below format of large number of rows. The Data field is of type string.

   Time               Identifier              Data
00:06:40.23             "300"           "65 00 69 00 6D 00 75 00 " 
00:06:40.25             "100"           "B7 FF E5 FF 7D 10 01 00 "

I need to split the Data column in to 4 columns with new names. i.e. as below

  Time                Identifier           AC1     AC2     AC3     AC4
00:06:40.23              "300"           "6500"  "6900"  "6D00"  "7500" 
00:06:40.25              "100"           "B7FF"  "E5FF"  "7D10"  "0100"

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

manoj hanu 2019-8-11

在 MATLAB Online 中打开

I tried first removing all the spaces with strrep.

A = strrep(table.Data, ' ', '');

Now got a string array in A without the spaces. Is there a better way in which this can be divided in to 4 columns now??

A = 2x1 string array
    "650069006D007500"
    "B7FFE5FF7D100100"

请先登录，再进行评论。

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

Answer 1

Bruno Luong 2019-8-11

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/475714-need-to-split-a-column-of-type-string-in-a-table-in-to-group-of-4-characters-giving-new-names-to-t#answer_387104

编辑：Bruno Luong 2019-8-11

在 MATLAB Online 中打开

s=[ "65 00 69 00 6D 00 75 00 "; 
    "B7 FF E5 FF 7D 10 01 00 "]
c = char(s);
c(:,3:3:end)=[];
ssplit = string(mat2cell(c,ones(1,size(c,1)),4*ones(1,4)))

Result

ssplit = 
  2×4 string array
    "6500"    "6900"    "6D00"    "7500"
    "B7FF"    "E5FF"    "7D10"    "0100"

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

manoj hanu 2019-8-15

在 MATLAB Online 中打开

Thank you for the answer. With your code I used

cell2table(ssplit, 'VariableNames' , { 'AC1' 'AC2' 'AC3' 'AC4'});

to get the columns named.

请先登录，再进行评论。

Answer 2

madhan ravi 2019-8-11

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/475714-need-to-split-a-column-of-type-string-in-a-table-in-to-group-of-4-characters-giving-new-names-to-t#answer_387115

在 MATLAB Online 中打开

v=regexp(strrep(T.Data,' ',''),'\w{4}','match');% naming a table with a variable name table is a terrible idea (will hinder the in-built function table())use T for example
AC = vertcat(v{:});
AC = array2table(AC); 
T.Data = [];
T = [T,AC]