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

Re: [TRNSYS-users] Data Reader Type 9d



Julian,

  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.

kind regards

 David


On 08/26/2019 09:10, Julian Schumann via TRNSYS-users wrote:

Hello TRNSYS Users,

 

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.

To read the data, I used Type 9d to skip the text columns and to read the data columns.

The problem is, that my data basis does not have the same amount of space in each column.

 

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.

In line 2, there are only 2 letters to skip with the tab and the data followed.

 

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).

 

Is there a way to read this data file without preprocessing the data?

 

Thanks for the support!

 

P.S. I am out of office for the rest of the week.

________________________________________________________________

 

M.Sc. Julian Schumann

 

Abteilung Solare Systeme

Solar systems department

 

Arbeitsgruppe Kollektoren

Workgroup Collectors

 

Institut für Solarenergieforschung GmbH

Am Ohrberg 1

D-31860 Emmerthal

 

Phone: +49 (0) 5151 999 521

Fax: +49 (0) 5151 999 500

 

eMail: j.schumann@isfh.de   

Internet: www.isfh.de 

 

Handelsregister: Amtsgericht Hannover HRB 100547

Geschäftsführer: Prof. Dr. Rolf Brendel

Vorsitzender des Aufsichtsrats: Ministerialrat Dr. Sebastian Huster

________________________________________________________________

 


¥2019 ISFH [1546297200]
_______________________________________________
TRNSYS-users mailing list
TRNSYS-users@lists.onebuilding.org
http://lists.onebuilding.org/listinfo.cgi/trnsys-users-onebuilding.org
-- 
***************************
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
d.bradley@tess-inc.com

http://www.tess-inc.com
http://www.trnsys.com