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 Data Type Conversion 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!