regexp split at first whitespace

Question

0 个投票

I have a cell dataset like this, where it is a string of letters and numbers all in one column (many rows):

data =
  '0R 2 2 0'
  '1R 2 0 0 4'
  '2R 2 2 0 1 1 1'
  '3R 2 2 2 1 1'

I would like to split each row into 2 columns at the first space:

data = 
  '0R'   '2 2 0'
  '1R'   '2 0 0 4'
  '2R'   '2 2 0 1 1 1'
  '3R'   '2 2 2 1 1'

I tried:

splitcells = regexp(data, '\s+','split');

but that splits at each space, creating numerous columns, not 2. How do I get the regular expression to split only at the first space? Thanks

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

Answer 1

Paolo 2018-7-14

3 个投票

You may use the once option to split only once at the first occurrence of whitespace.

splitcells = regexp(data,'\s','split','once')

Thanks so much! If anyone else has this question, you can use the following to unnest the 1x2 cells from the split:

data = vertcat(data{:});

Simon 2023-4-25

I have the same problem. Thanks for the answers!