How to change date format in file

Shell Programming and Scripting
1

Hello!

I have a textfile that look like this:

"83d1:46:2b";"20091008190000";"R�gle BK - Skellefte�";"Swedish"
"d4c:46:21";"20091008190000";"S�dert�lje - Bryn�s";"Swedish"
"d4b:46:2";"20091008190000";"HV 71 - F�rjestad";"Swedish"
"838:46:b";"20091010160000";"Skellefte� - HV 71";"Swedish"
"a119:46:2b";"20091010160000";"Modo - R�gle BK";"Swedish"
"83d:46:2b";"20091010160000";"Timr� - Link�ping";"Swedish"
etc
etc

And i want to change the date to epoch format, eg:

"838:46:2b";"1255021200";"Lule� - Djurg�rden";"Swedish"
"1139:46:2b";"1255021200";"Timr� - Modo";"Swedish"
"83d:46:2b";"1255021200";"R�gle BK - Skellefte�";"Swedish"
"d4c:46:2";"1255021200";"S�dert�lje - Bryn�s";"Swedish"
"d4b:46:21";"1255021200";"HV 71 - F�rjestad";"Swedish"
"838:46:b";"1255183200";"Skellefte� - HV 71";"Swedish"
"81b:46:2b";"1255183200";"Modo - R�gle BK";"Swedish" 
etc
etc

The system is SLES 11 x86

Is there an easy way to do this with a script?

Thanks in advice

2

With awk:

(n)awk version:

BEGIN{FS=OFS="\";\""}
{
  dte=substr($2,1,4) "-" substr($2,5,2) "-" substr($2,7,2) " " substr($2,9,2) ":" substr($2,11,2)
  sprintf("date -d'%s' +%%s", dte) | getline epoch
  $2=epoch
  print $0
}

GNU awk:

BEGIN{FS=OFS="\";\""}
{
  dte=substr($2,1,4) " " substr($2,5,2) " " substr($2,7,2) " " substr($2,9,2) " " substr($2,11,2) " " substr($2,13,2)
  $2=mktime(dte)
  print $0
}
3 
awk 'BEGIN{FS=OFS="\""}{"date -jf %Y%m%d%H%M%S "$4" +%s"| getline var;close("date -jf %Y%m%d%H%M%S "$4" +%s");$4=var}1' file

Work for me on FreeBSD :rolleyes: