[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



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

-- 
NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie!		
Jetzt informieren: http://www.gmx.net/de/go/freephone