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

JFz
2015 8 26
2 个回答
回答已采纳
更新时间：2019 7 12
30 次查看（30 天）

2 个投票

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 个评论
显示 -1更早的评论 隐藏 -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

4 个投票

Actually I did it with t.Var1 = strcat(t.Var1, '_', t.Var2)

更多回答（1 个）

Varun Bhaskar
Varun Bhaskar 2015-8-28

0 个投票

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 个评论
显示 -1更早的评论 隐藏 -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.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Characters and Strings 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by