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

123 次查看（过去 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 中查找有关 Dates and Time 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by