<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Le 15/10/2016 15:45, Samuel Gougeon a
écrit :<br>
</div>
<blockquote cite="mid:580232E7.4090505@free.fr" type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<div class="moz-cite-prefix">Hello<br>
<br>
Le 14/10/2016 00:08, Philipp Mühlmann a écrit :<br>
</div>
<blockquote
cite="mid:CACf7ODv4XbywHn_JzvKhMpS=pfFU2X8kmxu+trsSNJNVFzhoXQ@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<div>Dear Scilab users,<br>
<br>
</div>
having a data file (*.cvs) containg following format:<br>
<br>
<br>
</div>
HEADER-Line<br>
</div>
dd.mm.yyyy, HH:MM:<a moz-do-not-send="true"
href="http://SS.MS">SS.MS</a>, value01, value02<br>
<br clear="all">
<div>
<div>
<div>
<div>
<div>dd = day<br>
</div>
<div>mm = month<br>
</div>
<div>yyyy = year<br>
<br>
</div>
<div>HH = hour<br>
</div>
<div>MM = minute<br>
</div>
<div>SS = second<br>
</div>
<div>Ms = milli second<br>
<br>
</div>
<div>ValueXY = numerical value<br>
</div>
<div><br>
</div>
<div>Is it possible to use cvsRead in such a way to
define the separator beeing ',' and ':' at the same
time?<br>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
Beside the solution provided by Serge, if you wish to stick to
csvRead(), have you tried using its "substitute" option, with a
[":" ","] value?<br>
I didn't, but would be interested by results. </blockquote>
.<br>
It works: the substitution is done <b>before</b> the splitting. <br>
Example:<br>
The file.csv content:<br>
<tt>--------</tt><tt><br>
</tt><tt>Header line</tt><tt><br>
</tt><tt>12.08.2016, 13:54:18.45, 3.145, 548.4</tt><tt><br>
</tt><tt>--------</tt><tt><br>
</tt><tt>
<br>
-->csvRead("file.csv",",",[],"string",[":", ","],[],[],1)</tt><tt><br>
</tt><tt> ans =</tt><tt><br>
</tt><tt>!12.08.2016 13 54 18.45 3.145 548.4 !</tt><tt><br>
</tt><br>
Samuel<br>
<br>
</body>
</html>