Reading a txt file with different number of rows for each column

Hey guys, I want to read the following text file and to convert it to cell array. is there any way to remove columns that there are no variables in each cell of them? I'm currently using textscan, which reads all the '%s' columns and don't read the '%*s' columns. Is there any way to do it automatically?

    l  R  neutral  l  !MODE RECORD CR 1000
    l  R  neutral  l  .
    l  R  neutral  l  .
    l  R  neutral  l  .

(I want to remove the columns 5- RECORD, 6- CR, 7- 1000)

Answer 1

[Brett Shoelson]

Noga, Read the doc for textscan. There's a section on skipping columns.

Cheers,

Brett