Hi All... I have what I thought would be a simple problem but I can't seem to find an example or pointer anywhere to solve it.
I have a simple CSV file with weather data in it.
It includes a timestamp for the data that is in UTC.
I need to convert that timestamp into local time.
Now I should be able to use sed to grab the correct data out of the file, but how can I do the math to change the date?
Thank you ever so much. Here's the file:
Timestamp,Temp,Chill,HIndex,Humid,Dewpt,Wind,HiWin d,WindDir,Rain,Barom,Solar,ET,UV
20071128 06:58:10,0.3,0.3,0.3,96,-0.2,0,3,19,0.5,1030.2 +