Clear Filters
Clear Filters

How can I merge text to numeric data?

1 view (last 30 days)
I have two variables:
A = [1 2 3 4 5 6 7 8 9 10]';
B = ["L", "R"]';
How can I merge A and B where B is of the same height (number of rows) as A? In other words, I want to have a second colum of alternating "L" and "R" .
Appreciate any help. Thanks.

Accepted Answer

KALYAN ACHARJYA
KALYAN ACHARJYA on 13 Feb 2021
Edited: KALYAN ACHARJYA on 13 Feb 2021
A = [1 2 3 4 5 6 7 8 9 10]';
B = ["L", "R"]';
r=length(A)/length(B);
B_update=repmat(B,[r,1])
t=table(A,B_update)
Result:
t =
10×2 table
A B_update
__ ________
1 "L"
2 "R"
3 "L"
4 "R"
5 "L"
6 "R"
7 "L"
8 "R"
9 "L"
10 "R"
  2 Comments
Walter Roberson
Walter Roberson on 13 Feb 2021
Note that it is not possible to have a numeric array that combines numbers and text, which is why the above solution puts the data into a table.
Benjamin Horsley
Benjamin Horsley on 13 Feb 2021
Thank you, guys! Really appreciate the help and explanation.

Sign in to comment.

More Answers (0)

Categories

Find more on Characters and Strings in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!