MATLAB: How to split a column in a table into two columns

Question

Hi,

I have a table that has column like this:

name_num
ABC_123
EFG_456
GGGG
HHHHH

I would like to split the column into two: name and num like this:

name    num
ABC     123
EFG     456
GGGG    N/A
HHHHH   N/A

I thought of varfun but I have difficulty with it. Would anyone help me?

Thank you.

Jennifer

Answer 1

name_num={'ABC_123','EFG_456','GGGG','HHHHH'}
s1=regexp(name_num,'[^\d_]+','match')
s2=regexp(name_num,'\d+','match')
s2(cellfun(@isempty,s2))={'N/A'}
out=[[s1{:}]' [s2{:}]']