<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Julian,</p>
<p> The two options I see are either to edit the file and "clean it
up" so that the text columns all have the same number of
characters or (and probably preferably) you can open up the file
in Excel and strip out the text column, save a copy of the file as
a *.csv file, then read it with an unformatted reading version of
Type9.</p>
<p>kind regards</p>
<p> David</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 08/26/2019 09:10, Julian Schumann
via TRNSYS-users wrote:<br>
</div>
<blockquote type="cite"
cite="mid:kcis.13E3BA38B6E8466884B73EAF549B21FC@hermes.intern.isfh.de">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hello TRNSYS Users,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US">I am trying to read a
data file, provided by measurement data. The problem is,
that I have one column with text and another column with
data.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">To read the data, I used
Type 9d to skip the text columns and to read the data
columns.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The problem is, that my
data basis does not have the same amount of space in each
column.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">As you can see in the
example.txt (appendix), the first line has 4 letters to
skip, then a tab and after that the data to read.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">In line 2, there are
only 2 letters to skip with the tab and the data followed.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The same problem occurs,
if I try to read the data column itself, because the first
line consists of a value of 0.0 (that would be F3.1 to read)
and the third line consists of a value of 24.57 (that would
be F5.2 to read).<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Is there a way to read
this data file without preprocessing the data?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Thanks for the support!<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:10.5pt;font-family:"Arial",sans-serif;color:black;background:white"
lang="EN-US">P.S. I am out of office for the rest of the
week.</span><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:Consolas;color:#17365D;mso-fareast-language:DE">________________________________________________________________</span><span
style="color:#17365D;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"
style="margin-left:35.4pt;text-autospace:none"><span
style="color:#17365D;mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:#17365D;mso-fareast-language:DE">M.Sc. Julian
Schumann<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:#17365D;mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:#17365D;mso-fareast-language:DE">Abteilung
Solare Systeme<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><i><span
style="color:#17365D;mso-fareast-language:DE">Solar
systems department<o:p></o:p></span></i></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:#17365D;mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:#17365D;mso-fareast-language:DE">Arbeitsgruppe Kollektoren<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><i><span
style="color:#17365D;mso-fareast-language:DE">Workgroup
Collectors<o:p></o:p></span></i></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="color:#17365D;mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:DE">Institut
für Solarenergieforschung GmbH <o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:DE">Am
Ohrberg 1 <o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:DE">D-31860
Emmerthal <o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:DE">Phone:
+49 (0) 5151 999 521<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:DE"
lang="EN-US">Fax: +49 (0) 5151 999 500 <o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:DE"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:DE"
lang="EN-GB">eMail: </span><u><span
style="font-size:10.0pt;color:blue;mso-fareast-language:DE"><a
href="mailto:j.schumann@isfh.de" moz-do-not-send="true"><span
style="color:#0563C1" lang="EN-GB">j.schumann@isfh.de</span></a></span></u><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:DE"
lang="EN-GB"> </span><span
style="font-size:10.0pt;color:#0000CC;mso-fareast-language:DE"
lang="EN-GB"> </span><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:DE"
lang="EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:DE">Internet:
<a href="http://www.isfh.de/" moz-do-not-send="true"><span
style="color:#0563C1">www.isfh.de</span></a> <o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:DE">Handelsregister:
Amtsgericht Hannover HRB 100547 <o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:DE">Geschäftsführer:
Prof. Dr. Rolf Brendel <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:DE">Vorsitzender
des Aufsichtsrats: Ministerialrat Dr. Sebastian Huster</span><i><span
style="color:#0033CC;mso-fareast-language:DE"><o:p></o:p></span></i></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:Consolas;color:#17365D;mso-fareast-language:DE">________________________________________________________________</span><span
style="color:#17365D;mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<small>¥2019 ISFH [1546297200]</small>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
TRNSYS-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:TRNSYS-users@lists.onebuilding.org">TRNSYS-users@lists.onebuilding.org</a>
<a class="moz-txt-link-freetext" href="http://lists.onebuilding.org/listinfo.cgi/trnsys-users-onebuilding.org">http://lists.onebuilding.org/listinfo.cgi/trnsys-users-onebuilding.org</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
***************************
David BRADLEY
Principal
Thermal Energy Systems Specialists, LLC
3 North Pinckney Street - suite 202
Madison, WI 53703 USA
P:+1.608.274.2577
F:+1.608.278.1475
<a class="moz-txt-link-abbreviated" href="mailto:d.bradley@tess-inc.com">d.bradley@tess-inc.com</a>
<a class="moz-txt-link-freetext" href="http://www.tess-inc.com">http://www.tess-inc.com</a>
<a class="moz-txt-link-freetext" href="http://www.trnsys.com">http://www.trnsys.com</a></pre>
</body>
</html>