You could try attached perl script. It converts a comma or tab separeted csv into an excel and does some stripping of leading and trailing white space.
Hope this helps,
Wouter
On 12/12/2010 07:26 PM, Thodwris Xaritidis wrote:
Actually the format is set to be date (but randomly, only in some of my outputs). when I change it to number,
it messes everything up..
From: "James V Dirkes II, PE" <jim@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
To: EnergyPlus_Support@xxxxxxxxxxxxxxx
Sent: Sun, December 12, 2010 6:19:39 PM
Subject: RE: [EnergyPlus_Support] pRoblems with open office (outputs)
Here’s an idea: Excel displays dates or numbers depending on the formatting of the cell. Might your format be causing this?
The Building Performance Team
James V. Dirkes II, P.E., LEED AP
1631 Acacia Drive NW
Grand Rapids, MI 49504
616 450 8653
From: EnergyPlus_Support@xxxxxxxxxxxxxxx [mailto:EnergyPlus_Support@xxxxxxxxxxxxxxx] On Behalf Of Thodwris Xaritidis
Sent: Sunday, December 12, 2010 10:52 AM
To: EnergyPlus_Support@xxxxxxxxxxxxxxx
Subject: [EnergyPlus_Support] pRoblems with open office (outputs)
Hello, I am now having very weird outputs in open office. Instead of temperatures I am having dates!!!!!!
What could be wrong? Anyone knows what to do? I checked my outputs in the proper
excell 2010 and they were fine..
HELP me
__._,_.___
Primary EnergyPlus support is found at:
http://energyplus.helpserve.com or send a message to energyplus-support@xxxxxxxx
The primary EnergyPlus web site is found at:
http://www.energyplus.gov
The group web site is:
http://groups.yahoo.com/group/EnergyPlus_Support/
Attachments are currently allowed but be mindful that not everyone has a high speed connection. Limit attachments to small files.
EnergyPlus Documentation is searchable. Open EPlusMainMenu.pdf under the Documentation link and press the "search" button.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___