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 <firstname.lastname@example.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:
12.08.2016, 13:54:18.45, 3.145, 548.4
!12.08.2016 13 54 18.45 3.145 548.4 !
users mailing list