Read specific column from txt file

Hi, I would like to read specific column from txt file (values - 3230,3190,3220 and so on). So how can I do it?

Thanks.

Here is the txt file looks like:

1 7/19/2012 11:46:38 AM L 0 254 3230 3.6 0.18 97

1 7/19/2012 11:46:52 AM L 0 249 3190 3.6 0.18 97

1 7/19/2012 11:47:05 AM L 0 252 3220 3.6 0.18 97

2 7/19/2012 11:49:05 AM L 0 390 4180 4.2 0.18 95

2 7/19/2012 11:53:09 AM L 0 399 4240 4.5 0.18 91

Answer 1

[bym]

fid = fopen('test.txt')
n = textscan(fid,'%*d %*s %*s %*s %*s %*f %*f %f %*f %*f %*f','delimiter',' ')
n{:}

ans =

        3230
        3190
        3220
        4180
        4240

[Aleksandra]

Thanks! But I don't know why it doesn't work.

It says n =

    [0x1 double]

ans =

   Empty matrix: 0-by-1

[Walter Roberson]

It would be safer to remove the embedded blanks in the format string. Also, since all those fields are being thrown away, it does not make sense to do the extra processing of deciding whether they are proper numeric form. Suggested format:

[repmat('%*s',1,6), '%f', repmat('%*s',1,3)]

Also, is your delimiter blanks or tabs? It looks like blanks, but I cannot be sure. If it is blanks, you can also drop the explicit 'delimiter' parameter/value pair.

[Aleksandra]

Yeah, I didn't use 'delimiter' since thre is no delimiter there. Thanks a lot!!