<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
The test data I posted had been preprocessed manually by equalizing
the spaces between the colums to a single one. The original output
of the MICA astro software aligns the colums tidily so that the
number of spaces varies along a line and from line to line if the
values vary between 1 and 3 digits. One can fix that with regex. It
would be workflow supporting if the separator input of<font
face="Courier New, Courier, monospace"><font face="Helvetica,
Arial, sans-serif"></font> csvRead</font> would interpret
several blanks as equivalent to one or if automation could be
acchieved elsewise.<br>
<pre style="font-family:Monospaced;font-style:normal;font-size:13.0;"><big><big><font color="#330033">Jens</font></big></big>
--------------------------------------------------------------------------------------------------------------------------------------------------
</pre>
Am 22.03.2017 23:55, schrieb Jan Åge Langeland:<br>
<blockquote
cite="mid:492a979d-c3b5-1e5d-ab61-163aea51e30a@online.no"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
On 22.03.2017 14:49, Jens Simon Strom wrote:<br>
<blockquote cite="mid:58D28101.1020006@hslmg.de" type="cite">
<pre style="font-family:Monospaced;font-style:normal;font-size:13.0;"><span style="color:rgb(92,92,92);"></span>
<big><big> Would you get to <span style="color:rgb(0,0,0);"><font face="Courier New, Courier, monospace">BAThour</font> and <font face="Courier New, Courier, monospace">BATminute</font></span> the same way?</big></big>
</pre>
</blockquote>
I would probably have done it in a more complicated way<span
class="moz-smiley-s1"><span>:-)</span></span>, but I like this
solution, it seems quite robust for characters replacing missing
numbers.<br>
<br>
In case your number of header lines varies:<br>
<pre style="font-family:Monospaced;font-style:normal;font-size:12.0;"><span style="color:rgb(0,0,0);">firstdata</span><span style="color:rgb(92,92,92);">=</span><span style="color:rgb(188,143,143);">"</span><span style="color:rgb(188,143,143);">2017</span><span style="color:rgb(188,143,143);">"</span><span style="color:rgb(100,174,100);font-style:italic;">//something unique in the first dataline</span>(or last header line)
<span style="color:rgb(0,0,0);">maxheaderlength</span><span style="color:rgb(92,92,92);">=</span><span style="color:rgb(188,143,143);">10</span>
<span style="color:rgb(0,0,0);">Mh</span><span style="color:rgb(92,92,92);">=</span><span style="color:rgb(50,185,185);">mgetl</span><span style="color:rgb(74,85,219);">(</span><span style="color:rgb(0,0,0);">filename</span><span style="color:rgb(0,0,0);">,</span><span style="color:rgb(0,0,0);">maxheaderlength</span><span style="color:rgb(74,85,219);">)</span>
<span style="color:rgb(160,32,240);">for</span> <span style="color:rgb(0,0,0);">skiplines</span><span style="color:rgb(92,92,92);">=</span><span style="color:rgb(188,143,143);">1</span><span style="color:rgb(255,170,0);">:</span><span style="color:rgb(50,185,185);">size</span><span style="color:rgb(74,85,219);">(</span><span style="color:rgb(0,0,0);">Mh</span><span style="color:rgb(0,0,0);">,</span><span style="color:rgb(188,143,143);">1</span><span style="color:rgb(74,85,219);">)</span>
<span style="color:rgb(160,32,240);">if</span> <span style="color:rgb(50,185,185);">strindex</span><span style="color:rgb(74,85,219);">(</span><span style="color:rgb(0,0,0);">Mh</span><span style="color:rgb(74,85,219);">(</span><span style="color:rgb(0,0,0);">skiplines</span><span style="color:rgb(74,85,219);">)</span><span style="color:rgb(0,0,0);">,</span><span style="color:rgb(0,0,0);">firstdata</span><span style="color:rgb(74,85,219);">)</span><span style="color:rgb(92,92,92);">~=</span><span style="color:rgb(74,85,219);">[</span><span style="color:rgb(74,85,219);">]</span> <span style="color:rgb(160,32,240);">then</span>
<span style="color:rgb(95,158,160);">break</span>
<span style="color:rgb(160,32,240);">end</span>
<span style="color:rgb(160,32,240);">end</span>
<span style="color:rgb(0,0,0);">skiplines</span><span style="color:rgb(92,92,92);">=</span><span style="color:rgb(0,0,0);">skiplines</span><span style="color:rgb(92,92,92);">-</span><span style="color:rgb(188,143,143);">1</span>
<span style="color:rgb(0,0,0);">Md</span><span style="color:rgb(92,92,92);">=</span><span style="color:rgb(50,185,185);">csvRead</span><span style="color:rgb(74,85,219);">(</span><span style="color:rgb(0,0,0);">filename</span><span style="color:rgb(0,0,0);">,</span><span style="color:rgb(188,143,143);">"</span><span style="color:rgb(188,143,143);"> </span><span style="color:rgb(188,143,143);">"</span><span style="color:rgb(0,0,0);">,</span><span style="color:rgb(74,85,219);">[</span><span style="color:rgb(74,85,219);">]</span><span style="color:rgb(0,0,0);">,</span><span style="color:rgb(188,143,143);">"</span><span style="color:rgb(188,143,143);">string</span><span style="color:rgb(188,143,143);">"</span><span style="color:rgb(0,0,0);">,</span><span style="color:rgb(74,85,219);">[</span><span style="color:rgb(74,85,219);">]</span><span style="color:rgb(0,0,0);">,</span><span style="color:rgb(74,85,219);">[</span><span style="color:rgb(74,85,219);">]</span><span style="color:rgb(0,0
,0);">,</span><span style="color:rgb(74,85,219);">[</span><span style="color:rgb(74,85,219);">]</span><span style="color:rgb(0,0,0);">,</span><span style="color:rgb(0,0,0);">skiplines</span><span style="color:rgb(74,85,219);">)
</span>
<span style="color:rgb(74,85,219);"></span><span style="color:rgb(74,85,219);"></span></pre>
Jan-Åge<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:users@lists.scilab.org">users@lists.scilab.org</a>
<a class="moz-txt-link-freetext" href="http://lists.scilab.org/mailman/listinfo/users">http://lists.scilab.org/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>