I have a Table in MATLAB. In one colum, lots of texts are seperated in comma. I wish to delimate those in seperate colums.
1 回表示 (過去 30 日間)
古いコメントを表示
I have a Table in MATLAB. In one colum, lots of texts are seperated in comma. I wish to delimate those in seperate colums.
clc
clear
raw=readtable('Service.xlsx');
r=0;
raw_problem=raw.Expert_Found_Problems;
P=height(raw);
for i=1:1:P
PROBLEMS=raw_problem{i,1};
C = strsplit(PROBLEMS,',')
r=r+1
T(r,:)=table(C)
end
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/242306/image.png)
![44.png](https://www.mathworks.com/matlabcentral/answers/uploaded_files/242308/44.png)
0 件のコメント
採用された回答
Guillaume
2019 年 10 月 12 日
It's not clear what you want as an output since for each row you're going to get a different number of elements after the split. Maybe:
raw.Expert_Found_Problems = cellfun(@(s) strsplit(s, ','), raw.Expert_Found_Problems, 'UniformOutput', false);
which creates a column cell array of cell arrays.
0 件のコメント
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Text Files についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!