<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font size="-1"><font face="Arial">Dear Igor,<br>
<br>
You may use Type 25c (Printer - Unformatted - No Units) and
define output file directly with xls extension. EXCEL file will
be created with output data you want to observe.<br>
<br>
To deal with your current data text file :<br>
</font></font>
<ol>
<li><font size="-1"><font face="Arial">open EXCEL, <br>
</font></font></li>
<li><font size="-1"><font face="Arial">open your text file with
EXCEL (File/Open/select all files extension) <br>
</font></font></li>
<li> the Convert Text to Columns Wizard<font size="-1"><font
face="Arial"> is then launched to convert your data in
columns with desired separated caracters.</font></font></li>
</ol>
<font size="-1"><font face="Arial"><br>
You can dot it directly in EXCEL :<br>
</font></font>
<ol>
<li>Select cells that contain the text-formatted times</li>
<li>Choose "Text to Columns" from the Data menu. (In Excel 2007,
select "Text to Columns" from the "Data" tab of the ribbon.)
Excel launches the Convert Text to Columns Wizard</li>
<li>Your data will then be converted</li>
</ol>
Best regards<font size="-1"><font face="Arial"><br>
</font></font>
<div class="moz-signature">
<hr align="LEFT" color="#3300FF" size="2" width="450">
<font color="#DC143C" face="CALIBRI" size="2"> Je serai absent du
1er au 28 Août 2011
<table border="0">
<tbody>
<tr>
<td rowspan="3" width="120">
<center><a href="http://www.itf.biz"><img
src="cid:part1.00060809.05090409@itf.biz"
alt="www.itf.biz" border="0" height="103"
width="66"></a><br>
<font color=" #0000FF" face="CALIBRI" size="1"><a
href="http://www.itf.biz">www.itf.biz</a></font></center>
</td>
<td colspan="2"><font color="#000000" face="CALIBRI"
size="2">Adrien JEZEQUEL<br>
Simulations Thermiques Dynamiques</font></td>
</tr>
<tr>
<td align="LEFT"> <font color="#0000FF" face="CALIBRI"
size="4"><b>ITF</b></font><br>
</td>
<td><font color="#0000FF" face="CALIBRI" size="2">62, Rue
du Bolliet<br>
73230 St Alban Leysse<br>
FRANCE<br>
</font></td>
</tr>
<tr>
<td align="LEFT" width="40"><font color="#0000FF"
face="CALIBRI" size="2"> Phone :<br>
Fax :<br>
Mail:<br>
</font>
</td>
<td><font color="#0000FF" face="CALIBRI" size="2"> +33(0)
479 750 029<br>
+33(0) 479 852 122<br>
<a class="moz-txt-link-freetext"
href="mailto:a.jezequel@itf.biz">a.jezequel@itf.biz</a>
ou <a class="moz-txt-link-freetext"
href="mailto:aj@itf.biz">aj@itf.biz</a></font></td>
</tr>
</tbody>
</table>
<i><font color="#008000" face="CALIBRI" size="1">Afin de
contribuer au respect de l'environnement, merci de
n'imprimer cet e-mail que si nécessaire<br>
<font color="#008000" face="CALIBRI" size="1">Please,
consider our environmental responsability before printing
this email<br>
</font></font></i>
</font></div>
<br>
Le 21/07/2011 12:23, Igor Grujic a écrit :
<blockquote cite="mid:20110721102351.127640@gmx.net" type="cite">
<pre wrap="">Dear TRNSYS-users,
Two Questions about the output format of Type65c and Type25f
Type25f:
Does anybody know how to delimit two columns with a tab?
I have to print 14 values in 1hr-steps, some like this
TIME X1 X2 X3 … X14
1 14.0 12.47 24.14 … 47.27
I tried Type 25f and set the „delimiter to 0”.
I set the format in Special Card to:
F12.2,1X,F12.2,1X,F12.2,1X,F12.2,1X,F12.2,1X,F12.2,1X,F12.2,1X,F12.2,1X
,F12.2,1X,F12.2,1X,F12.2,1X,F12.2,1X,F12.2,1X,F12.2,1X,F12.2
The problem is that in the .txt-file the columns are separated with spaces instead of tabs.
When I try to copy it to a .xls-file, excel don’t recognized the singly columns and wrote it in one line, for example:
Excel cell A1: 1 14.0 12.47 24.14 …. 47.27
The Cells B2 (where I want to have the X2-items) or C2 and so on are all empty.
Does someone have I idea?
Type65c:
Is it possible to change the output-format, for example instead of "7.9536548752145686E+01" to "79,54"??
Thanks in advance
Kind regards,
Igor
</pre>
</blockquote>
</body>
</html>