清空筛选条件
清空筛选条件

How to concatenate two columns in one table into one column?

98 次查看（过去 30 天）
JFz
JFz 2015-8-26
评论： Peter Jarosi 2019-7-12
Hi,
I have a table of 5 columns with strings, I would like to concatenate the two columns by a "_" and make them into one column.
Table A:
var1 var2 var3 var4 var5 ABC 123 aaa bbb ccc EFG 345 ddd eee fff into B: var1 ABC_123 EFG_345
How to do that?
Thanks.
Jennifer
  1 个评论
JFz
JFz 2015-8-26
In addition, in the var2, there are some string like 'N/A'. I want to replace 'N/A' by just nothing ''.
Thanks for any help.
Jennifer

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

JFz
JFz 2015-8-28
Actually I did it with t.Var1 = strcat(t.Var1, '_', t.Var2)

更多回答（1 个）

Varun Bhaskar
Varun Bhaskar 2015-8-28
Hi,
It is not possible to concatenate two columns after the table has been constructed. You can concatenate the two columns prior to constructing the table using the 'strcat' function.
  1 个评论
Peter Jarosi
Peter Jarosi 2019-7-12
Eh,
It's not true. I tried JFz's idea for tables already been constructed. It works! At least in Matlab 2016a or later versions.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by