Split structured text delimated by comma in a table column

Question

mahesh kamad 2023-3-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1922695-split-structured-text-delimated-by-comma-in-a-table-column

编辑： the cyclist 2023-3-3

I have a table containing a variable for airport which has structured string values like Airport = ["MUMBAI,BOM";"NEW DELHI, DLH"; "JAIPUR,JAI";.......] How to split this variable in two different new variables in same table with one variable having location and another as loaction code.

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

请先登录，再进行评论。

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

Answer 1

the cyclist 2023-3-3

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1922695-split-structured-text-delimated-by-comma-in-a-table-column#answer_1184805

编辑：the cyclist 2023-3-3

在 MATLAB Online 中打开

% Create the sample input table
Airport = ["MUMBAI,BOM"; "NEW DELHI, DLH"; "JAIPUR,JAI"];
tbl = table(Airport);
% Create temporary string array, with two columns split at the comma
tmp= split(tbl.Airport,",");
% Extract the location, and put in table
tbl.Location = tmp(:,1);
% Extract the code, and put in table
tbl.Code = tmp(:,2);
tbl
tbl = 3×3 table
        Airport          Location       Code 
    ________________    ___________    ______

    "MUMBAI,BOM"        "MUMBAI"       "BOM" 
    "NEW DELHI, DLH"    "NEW DELHI"    " DLH"
    "JAIPUR,JAI"        "JAIPUR"       "JAI" 