How to go from a char that is a CSV to a cell array

Question

Will Kinsman 2016-3-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/270836-how-to-go-from-a-char-that-is-a-csv-to-a-cell-array

回答： Jos (10584) 2016-3-1

Hello all,

I have a char variable that is essentially a CSV file, however all attempts to turn it into a cell array (through simple means) have failed. Lets say my char variable looks like:

inputchar = 'name,bob,joe,paul
             age,12,43,15'

(note there is a \n after paul) I would like my output to simply be a cell array to appear as:

outputcellarray = {'name','bob','joe','paul';
                   'age',12,43,15}

While I am aware of csvread, since I am trying to read from a char variable instead of a CSV file, I am having trouble. Any suggestions or simple workarounds other than writing an entire function to do this?

Thanks so much for the help everyone! Will

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

请先登录，再进行评论。

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

Answer 1

Jos (10584) 2016-3-1

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/270836-how-to-go-from-a-char-that-is-a-csv-to-a-cell-array#answer_211860

在 MATLAB Online 中打开

Are you sure you want to store your data like this, i.e., all in a single cell array? Take a look at textscan to read you cvs file. Otherwise this might do the trick:

inputchar = 'name,bob,joe,paul\nage,12,43,15'
X = strrep(inputchar,'\n',',')      % get rid of the line break
C = strread(X,'%s','delimiter',',') % read everything as a string
C = reshape(C,[],2).'               % reshape in right format
V = str2double(C)                   % convert numbers
tf = ~isnan(V)                      % find these numbers
C(tf) = num2cell(V(tf))             % put them in place. Voila!