Hello Assuming you have two header lines in your files, try this:
tt=csvRead(log_file,";",[],"double",[".",";";":",";";",",";"],[],[],2) tv=datenum(tt(:,3),tt(:,2),tt(:,1),tt(:,4),tt(:,5),0) td=datevec(tv) Jan On 07.11.2017 15:38, Richard llom wrote:
Hello, I have logfiles in the following form: DESC: AAA 2017 Datum;Zeit;kWh 01.01.2017;06:00;419,942 01.01.2017;07:00;513,273 01.01.2017;08:00;478,268 01.01.2017;09:00;711,572 01.01.2017;10:00;606,592 01.01.2017;11:00;594,92 01.01.2017;12:00;594,92 01.01.2017;13:00;524,933 ... I can read these in either as double or string [log_data, comments] = csvRead(log_file, ";", ",", "double",[], "/^[^0-9\-]/"); [log_data, comments] = csvRead(log_file, ";", ",", "string",[], "/^[^0-9\-]/"); However what I'm missing is a way to convert the date & time column to a date format in scilab. There doesn't seem to be function for this in scilab. Is there a recommended way of doing so? Thanks & regards richard PS: I'm so glad the list is working again! Would have been nice tho to inform the users in advance and with some sort of status.scilab.org site or something... -- Sent from: http://mailinglists.scilab.org/Scilab-users-Mailing-Lists-Archives-f2602246.html _______________________________________________ users mailing list users@lists.scilab.org http://lists.scilab.org/mailman/listinfo/users
_______________________________________________ users mailing list users@lists.scilab.org http://lists.scilab.org/mailman/listinfo/users
