My input file is a comma separated .csv. I'd like to convert the 2nd columns from unix time to a readable date time format like this...
before 1502280000 after 8/10/17 08:00:00
I'd also like to ignore the first row as it is headers.
I'm running in a bash shell on Solaris 10
the first two rows of my csv look like this
HOST,DATE_TIME_CREATED,USER_ID,EVENT_CLASS xxxx,1502286180,xxxx,xxxx xxxx,1502280347,xxxx,xxxx
looking for output of
HOST,DATE_TIME_CREATED,USER_ID,EVENT_CLASS xxxx,Wed Aug 9 09:43:00 EDT 2017,xxxx,xxxx xxxx,Wed Aug 9 08:05:47 EDT 2017,xxxx,xxxx