Re: [TRNSYS-users] Output-format for Type65c and Type25f

[Adrien JEZEQUEL - ITF <a.jezequel@itf.biz>]

Dear Igor,

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.

To deal with your current data text file :

1. open EXCEL,
   
2. open your text file with EXCEL (File/Open/select all files extension)
   
3. the Convert Text to Columns Wizard is then launched to convert your data in columns with desired separated caracters.

You can dot it directly in EXCEL :

1. Select cells that contain the text-formatted times
2. 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
3. Your data will then be converted

Best regards

---

Je serai absent du 1er au 28 Août 2011

www.itf.biz	Adrien JEZEQUEL Simulations Thermiques Dynamiques
	ITF	62, Rue du Bolliet 73230 St Alban Leysse FRANCE
	Phone : Fax : Mail:	+33(0) 479 750 029 +33(0) 479 852 122 a.jezequel@itf.biz ou aj@itf.biz

Afin de contribuer au respect de l'environnement, merci de n'imprimer cet e-mail que si nécessaire
Please, consider our environmental responsability before printing this email

Le 21/07/2011 12:23, Igor Grujic a écrit :

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