I have a text file with many thousands of rows which look like this
20120601 000000603,1.234610,1.234780,0
where the first two whitespace separated columns are a date and time representation and the following three comma separated columns are data. I want to read the text file into an Octave matrix such that the columns of the matrix are separated thus.
2012 06 01 00 00 00 603 1.234610 1.234780 0
I’m sure the textscan function is what I’ll need to use, but I don’t know the format string to separate things as I want.