I have a problem with importing a data file, and I hope someone in here can help resolve it. The file I'm trying to import looks like this (headers not included!):
01-11-2012 00:00:00 52,0837766666504 -2752,54346603125 0 -4280 1 1 2 2 0 0
01-11-2012 00:00:10 55,0510711669922 -2052,33987375 0 -9240 1 1 2 2 0 0
01-11-2012 00:00:20 58,0332733895508 -2952,54345703125 0 -3240 1 1 2 2 0 0
A total of 11 columns separated by tab, stored in a .txt file.
The problem is:
- 1st column has date and time, which Matlab seems to have troubles with
- 2nd and 3rd uses comma decimal instead of a dot, which makes Matlab see it as text
I've tried to load the file with the function "load" - which isn't possible because of the mix of data and text. Then I tried using "textscan" which results in an array inside an array, with completely messed up data (all headers in a 1x1 array fx).
Using the following code:
filename = 'test.txt';
delimiterIn = ' ';
headerlinesIn = 1;
A = importdata(filename,delimiterIn,headerlinesIn);
Produced a 1x1 array with all the headers and nothing else (I also tried /t for the delimiter, which didn't work at all).
So this is the point where I hope someone in here can help :) Thanks in advance, and a Merry Christmas to you all! :)