how can I combine two columns of an array A(m*2) in one column in the format: column1(column2)?

2 views (last 30 days)
i have a cell array A(m*2). the first column of consist of R and P characters and second column is just numbers. now i want put 2 columns together in the format P(number) or R(number) in which the numbers inside parenthesis are the elements of second column. can any one help with this?
thank you;
  2 Comments
Image Analyst
Image Analyst on 20 Oct 2015
I don't understand. You can't have characters and numbers in the same column vector. Please give an example.
Joseph
Joseph on 20 Oct 2015
Edited: Joseph on 20 Oct 2015
example: linlist=horzcat(Branch,num2cell(JJ));
JJ is a matrix that includes numbers and Branch is a cell that includes characters(in this case, R and P). i put them together using horzscat and made linlist cell.

Sign in to comment.

Accepted Answer

Mohammad Abouali
Mohammad Abouali on 20 Oct 2015
So, if I understood you right you have A of size Mx2 where the first column has either the character R or P and the second column has a number. You want to have two other variables One named R and another Named P which they contain the corresponding numbers from the second column of A?
If that's what you want here is a sample code:
A={'R',1; ...
'P',5; ...
'R',3; ...
'R',10; ...
'P',6; ...
'R',8};
R=cell2mat(A(strcmpi(A(:,1),'R'),2))
R =
1
3
10
8
P=cell2mat(A(strcmpi(A(:,1),'P'),2))
P =
5
6
  2 Comments
Joseph
Joseph on 20 Oct 2015
Edited: Joseph on 20 Oct 2015
i just want to make a string with the format P(number) or R(number)., in which the numbers belong to second column. i know that i can use strcat but i don't know how to put the numbers in second column in the parenthesis.
Joseph
Joseph on 20 Oct 2015
figured it out, thank you tho for your answer. i meant below:
out1=cell2mat(A);
out=strcat(A(:,1),'(',(num2str(out1(:,2))),')');

Sign in to comment.

More Answers (0)

Categories

Find more on Cell Arrays 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!