Extra Sensor Files: Difference between revisions

86 bytes added ,  12:15, 9 September 2013
m
Line 41: Line 41:
Edit the original file using an editor that treats all fields as text [either any text editor, a Comma Separated Value editor, or a spreadsheet program that can be instructed ''not'' to recognise special field (like date) types].  
Edit the original file using an editor that treats all fields as text [either any text editor, a Comma Separated Value editor, or a spreadsheet program that can be instructed ''not'' to recognise special field (like date) types].  
=== List of fields in the file ===
=== List of fields in the file ===
The field number (starting from zero) and the equivalent letter that would be seen in a spreadsheet like Libre Office, Open Office, Excel etc are listed here.
The field number (starting from zero to be consistent with index used for arrays in programming languages like JavaScript) and the equivalent letter that would be seen in a spreadsheet like Libre Office, Open Office, Excel etc are listed here.  
* 00(A): Date in the Windows short format of either dd/mm/yy or dd-mm-yy (separator is needed, but the symbol is unimportant)
* 00(A): Date in the Windows short format of either dd/mm/yy or dd-mm-yy (separator is needed, but the symbol is unimportant)
* 01(B): Current time in the format hh:mm using the 24 hour clock and local time (system time)   
* 01(B): Current time in the format hh:mm using the 24 hour clock and local time (system time)   
5,838

edits