Hi,
Is there a way in Split (or some other way) to convert the date and time in array data format to the date and time in table format?
Like 4,2008,70,1000,x,x,x into "2008-03-10 10:00:00",x,x,x
Thanks
For a mixed array data file that might look something like:
101,2007,283,1004,4.125,13.97,26.16,77.9,23.61,77.7,.215
101,2007,283,1005,5.125,13.97,26.16,77.9,23.27,77.6,.223
101,2007,283,1006,6.125,13.97,26.16,77.8,23.27,77.6,.194
101,2007,283,1007,7.13,13.97,26.15,77.8,23.61,77.7,.161
101,2007,283,1008,8.13,13.97,26.16,77.8,23.27,77.6,.179
101,2007,283,1009,9.13,13.97,26.16,77.9,23.27,77.6,.223
101,2007,283,10010,10.13,13.97,26.18,77.9,23.21,77.6,.247
101,2007,283,10011,11.13,13.97,26.15,77.8,23.21,77.6,.199
101,2007,283,10012,12.13,13.97,26.18,77.9,23.21,77.6,.3
(e.g., array id, year, julian day, hour/minute, data, data, data etc...)
You would use something like the following:
Copy Condition:
1[101]
Select Line:
date("yyyy-mm-dd hh:nn:ss";4;3;2),5,6,7,8, etc.....
On the Output tab, make sure to change the column width for column 1 to something like 25 or so, or you will get the error "Bad Data" when the par file is run.
The information on the "date" format, as well as the error message "bad data", is explained in the Split help file.
HTH,
Dana W
Thanks Dana,
Worked like a charm!
G