Convert array of comma separated strings in cells to matrix

30 次查看（过去 30 天）
Reid Elleman
Reid Elleman 2017-6-21
评论： Jon 2022-7-15
Wordy, I know, but here's the short story.
I have a cell matrix like this:
Arr = {
'0,2,3'
'1,4,5'
'2,6,7'
};
that I need converted to numeric values, preferably in a matrix like this:
Mat = [
0 2 3;
1 4 5;
2 6 7;
];
The array is tens of thousands of lines long. I am currently using brute force to go line by line and convert each cell to a vector using strsplit and concatenating each row onto the bottom of Mat. Can anybody offer a better suggestion?
Here's the big picture if it helps:
I have a log file like this:
crap
crap
crap
HeaderCol1,HeaderCol2
0,4
1,5
2,6
3,7
crap
crap
HeaderCol1,HeaderCol2,HeaderCol3
0,1,2
1,2,3
2,3,4
3,4,5
crap
I need to import and plot the larger block of data and smaller block separately.
any help is appreciated and thank you.
  1 个评论
Jon
Jon 2022-7-15
Looks like you got some answers here that you liked. Would be good if you accepted one of them so that others, like me would get pointed to the one you would suggest using.

请先登录，再进行评论。

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

回答（4 个）

Jan
Jan 2017-6-21
Arr = {
'0,2,3'
'1,4,5'
'2,6,7'};
Str = sprintf('%s,', Arr{:});
Num = sscanf(Str, '%g,', [3, inf]).';
  3 个评论
显示 1更早的评论
John Grant
John Grant 2019-8-3
I signed in just to thank you for this answer you gave, in delimiting comma spaced cell matrices. I've been struggling for hours, trying to breakup a cell matrix that had put all its data into 1 column, when it should have been 3 columns.

请先登录，再进行评论。

Walter Roberson
Walter Roberson 2017-6-22
Mat = cell2mat(cellfun(@str2num,Arr,'uniform',0));
Andrei Bobrov
Andrei Bobrov 2017-6-21
Arr = {
'0,2,3'
'1,4,5'
'2,6,7'
};
T = regexprep(Arr,',','');
Brr = cell2mat(arrayfun(@(x)T{x}-'0',(1:numel(T))','un',0))
Ahmet Karakaya
Ahmet Karakaya 2020-1-4
1.Choose cell array on the workspace
2.Right click and copy contents
3. Paste between brackets
Array = [ ]
4.Array is a numeric array

类别

在 Help Center 和 File Exchange 中查找有关 MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by