%// Read in data with importdata
data = importdata('data1.txt') %// 'data1.txt' is the input text file
%// Split data
split_data = cellfun(@(x) strsplit(x,' '),data,'Uni',0)
N = numel(split_data) %// number of rows in input textfile
%// Setup output cell and mask arrays
out_cell = cell(9,N)
mask = true(9,N)
%// Set the "type" entry as zero in mask array for the rows in textfile
%// that has corresponding entry missing
mask(7,cellfun(@length,split_data)~=9)=0
%// Use mask to set cells in out_cell from split data entries
out_cell(mask) = [split_data{:}]
out = out_cell'
樣品運行 -
>> type data1.txt
id id_2 s1 s2 st1 st2 type desig num
1 1 51371 51434 52858 52939 5:3_4:4_6:2_4:4_2:6 CO 1
2 1 108814 108928 109735 110856 5:3_4:4_6:2_4:4_2:7 CO 2
3 1 130975 131303 131303 132066 5:3_4:4_6:2_4:4_2:8 NCO 3
4 1 191704 191755 194625 194803 NCO 4
5 2 69355 69616 69901 70006 CO 5
6 2 202580 202724 204536 205151 5:3_4:4_6:2_4:4 CO 6
>> out
out =
'id' 'id_2' 's1' 's2' 'st1' 'st2' 'type' 'desig' 'num'
'1' '1' '51371' '51434' '52858' '52939' '5:3_4:4_6:2_4:4_2:6' 'CO' '1'
'2' '1' '108814' '108928' '109735' '110856' '5:3_4:4_6:2_4:4_2:7' 'CO' '2'
'3' '1' '130975' '131303' '131303' '132066' '5:3_4:4_6:2_4:4_2:8' 'NCO' '3'
'4' '1' '191704' '191755' '194625' '194803' [] 'NCO' '4'
'5' '2' '69355' '69616' '69901' '70006' [] 'CO' '5'
'6' '2' '202580' '202724' '204536' '205151' '5:3_4:4_6:2_4:4' 'CO' '6'