Modify date in file with Bash Script

[chrisale]

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 +