MATLAB: How to select columns of data (.dat)

read data

i have data in 732 file (.dat ) n this sample my data..
03:05:00 .000 065.501 01** 4864 0086 0074 +19
03:06:00 .000 065.501 01** 4862 0095 0074 +19
03:07:00 R- .026 065.501 01** 4862 0105 0074 +19
03:08:00 R- .180 065.504 01** 4864 0105 0074 +19
now i want to plot column 1 (time) with (column 3) divide 60 (rain) ..
1. how i can do that, because i think sometimes matlab read my data just have 8 column (when no rain (R-)). n sometimes matlab read 9 column.
when no rain R- replace with 2 space
2. how i can read all file.

Best Answer

You can use textscan(), and at the place where you might have the R- or might not, use %2c as the format. %c does not skip blanks. (Experiment: there is a chance you might need to use %*c%2c instead, to eat the space between fields.)