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
44.png

採用された回答

Guillaume
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 件)

カテゴリ

Help Center および File ExchangeText Files についてさらに検索

タグ

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by