MATLAB: Character in cell array, read and write

Question

Hello all,

I have a data in cell something like this:

1 BCS ACK/NACK 2054 0.00000 10.0000 Inside

[Note: actually I have 100 lines like above]

Now what I want to do is break this into different colum and save to excel sheet so that I can creat some graphs. Can anyone suggest how to, pls?

BR MJ

Answer 1

A={'1 BCS ACK/NACK 2054 0.00000 10.0000';'1 BCS ACK/NACK 2054 0.00000 10.0000'}
res=cellfun(@(x) regexp(x,' ','split'),A,'uni',false)
out=[]
for k=1:numel(res)
  out=[out;res{k}]
end
xlswrite('file.xls',out)