Help with parsing a csv

Hi,

I'm a fairly new user to MATLAB and programming. I need some help and guidance with the following problem.

I have a lot of csv files with only 1 line of data in each. The data in each csv looks like the following: 39605.000000,39605.333433,39605.333433,8.000000,0.000000,3.441000,4.239000,4.754000,5.179000

The first 5 columns looks like it is date/time related and the last 4 columns are the data values I need.

I am trying to create 4 new csv's from the 4 data values with the following format: 'yyyy.mm.dd.HH:MM:SS', data

Can anyone please help or provide me some guidance on how to get this accomplished? I've only been able to read the csv and get the data with fopen. I'm not sure how to change create the date format I need from the file.

[Wouter]

Try the textscan function.

[Tony]

I was able grab the data via textscan, but I'm not sure how to get the date into the format I need from those fields. Any guidance on that?

[per isakson]

39605.000000,39605.333433,39605.333433,8.000000,0.000000 doesn't look like date/time to me.

[Tony]

The 1st is date, 2nd and 3rd is date/time, 4th is hour and 5th is minute. I guess I would only need the 2nd column. When I try to use datestr, it says I can't use datestr on cells.

[Cedric]

Have you tried CSVREAD or DLMREAD ? The fact that you see a single line in your text editor doesn't mean that the content lies on a single line (especially if files were generated on a UNIX-like system and you open them using Windows notepad). The two aforementioned functions might be able to read the proper structure.

[per isakson]

Does data come from an excel-sheet? And thus, 1900 should be added to the "date"

    >> datestr( 39605, 'yyyy-mm-dd' )
    ans =
    0108-06-07

[Tony]

I got it to work with CSVREAD, I'm trying to create a new csv with the following method. Except instead of showing a 0 in the last like the code is trying to do, its showing 48... I have no idea where that is coming from

 dataLine = csvread(([archiveDir list1(j).name]));

    fid = fopen('temp.csv', 'w');
    fprintf(fid,'%s,%6.8f,%6.8f,%6.8f,%6.8f,%d\n', datestr(x2mdate(dataLine(2)),'yyyy.mm.dd.HH:MM:SS'),dataLine(6),dataLine(6),dataLine(6),dataLine(6),'0');
    fclose(fid);

[Tony]

This is the output:

2008.06.06.08:00:08,3.44100000,3.44100000,3.44100000,3.44100000,48

[per isakson]

Hint:

    >> double('0')
    ans =
        48
    >>