how to concatnate cells within a column

1 view (last 30 days)
andrew
andrew on 14 Aug 2013
i have a column of cells that i would like to group/concatnate into one row for example:
Carboplatin & pemetrexed maintenance pemetrexed docetaxel
should become this: Carboplatin & pemetrexed||maintenance pemetrexed||Docetaxel
how do i do this without having to manually input the following code:
a=strcat (data2.REGIMEN{1},'||',data2.REGIMEN{2},'||',data2.REGIMEN{3});
  2 Comments
Azzi Abdelmalek
Azzi Abdelmalek on 14 Aug 2013
Can you provide a short example with expected result?
andrew
andrew on 14 Aug 2013
for example column contains{5,6,7,8,9,10,11,12,13,14...etc} and
outcome should be in one cell {5,6,7}, {8,9,10,11},

Sign in to comment.

Answers (2)

dpb
dpb on 14 Aug 2013
Edited: dpb on 15 Aug 2013
s=char(d.reg(1));
for i=2:length(d.reg)
s=strcat(s,['||' char(d.reg(i))]);
end
Adding the "||" made trying to use comma list a pita in any way I could think of otomh, anyways...

F.
F. on 14 Aug 2013
I think you should try this:
% code
strcat( sprintf( '%s||', Data2 .REGIMEN{1:end-1} ) , Data2.REGIMEN{end} )
OR
% code
Tmp = strcat( Data2 .REGIMEN(1:end-1), '||' );
strcat( [ Tmp{:} ] , Data2.REGIMEN{end} )

Community Treasure Hunt

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

Start Hunting!