how to concatnate cells within a column
Show older comments
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
on 14 Aug 2013
Can you provide a short example with expected result?
andrew
on 14 Aug 2013
Answers (2)
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.
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} )
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!