[Scilab-users] using csvRead

[Samuel Gougeon]

Le 15/10/2016 15:45, Samuel Gougeon a écrit :
> Hello
>
> Le 14/10/2016 00:08, Philipp Mühlmann a écrit :
>> Dear Scilab users,
>>
>> having a data file (*.cvs) containg following format:
>>
>>
>> HEADER-Line
>> 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.
Example:
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  !

Samuel

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.scilab.org/pipermail/users/attachments/20161015/e4a0e13c/attachment.htm>