Hi Samuel,

As the data is loaded by csvRead as strings in the example below (if loading as 
doubles then we get NaN's), it will require further processing to convert it to 
numeric (using evstr, tokens or other).
For very large data files, this seems to be rather slow compared to the mfscanf 
or fscanfMat solutions.

What do you think?


From: users [mailto:users-boun...@lists.scilab.org] On Behalf Of Samuel Gougeon
Sent: Saturday, October 15, 2016 5:55 PM
To: Users mailing list for Scilab <users@lists.scilab.org>
Subject: Re: [Scilab-users] using csvRead

Le 15/10/2016 15:45, Samuel Gougeon a écrit :

Le 14/10/2016 00:08, Philipp Mühlmann a écrit :
Dear Scilab users,
having a data file (*.cvs) containg following format:

dd.mm.yyyy, HH:MM:SS.MS<http://SS.MS>, value01, value02

dd = day
mm = month
yyyy = year
HH = hour
MM = minute
SS = second
Ms = milli second
ValueXY = numerical value

Is it possible to use cvsRead in such a way to define the separator beeing ',' 
and ':' at the same time?
Beside the solution provided by Serge, if you wish to stick to csvRead(), have 
you tried using its "substitute" option, with a [":" ","] value?
I didn't, but would be interested by results.
It works: the substitution is done before the splitting.
The file.csv content:
Header line
12.08.2016, 13:54:18.45, 3.145, 548.4

-->csvRead("file.csv",",",[],"string",[":", ","],[],[],1)
 ans  =
!12.08.2016   13  54  18.45   3.145   548.4  !

users mailing list

Reply via email to