hello
i have exported one weeks worth of reading to and excel sheet, but can't make head nor tails of it??
any help on translating the data would be much appreciated .
»
Archived Forum |
|
How to read csv filesSubmitted by bobdylan on Sat, 14/03/2015 - 09:10hello i have exported one weeks worth of reading to and excel sheet, but can't make head nor tails of it?? any help on translating the data would be much appreciated .
» |
Re: How to read csv files
Hi. The Comma Seperated Variables file has 2 "columns" of data, a timestamp and a value. Unfortunately since the value has a "thousands seperator" comma the file is being corrupted into 3 columns when ever a value of 1000 or more is encountered.
This needs to be fixed upstream in the code as it has been mentioned a few times, but as a temporary fix you could 'concatenate' columns "B" & "C" eg row one should be 2810.81.
column A is a unix times stamp (seconds since 01/01/1970 00:00;00) I use this formula to "decode it"
=((($A1/1000/60)/60)/24)+DATE(1970,1,1)
Paul