Shell Programming and Scripting

2014-08-21 18:06:26,A,B,12345,123,C,1232,26/08/14 18:07

awk -F, 'NR <=1 {print;next}{"date +%d/%m/%Y\" \"%H:%m -d\""$1 "\""| getline dte;$1=dte}1' OFS="," test.csv

awk: cmd. line:1: (FILENAME=test.csv FNR=258) fatal: cannot create child process for `date +%d/%m/%Y" "%H:%m -d"2014-04-15 14:14:11"' (fork: Resource temporarily unavailable)

uname -a

Linux hostname 2.6.9-104.ELsmp #1 SMP Wed May 9 19:42:36 EDT 2012 i686 i686 i386 GNU/Linux

#!/bin/ksh93

while IFS="," read d1 v1 v2 v3 v4 v5 v6 d2
do
        printf "%(%m-%d-%Y %H:%M)T,%s,%(%m-%d-%Y %H:%M)T\n" "$d1" "$v1,$v2,$v3,$v4,$v5,$v6" "${d2:6:2}-${d2:3:2}-${d2:0:2} ${d2:9}"
done < file.csv

akshay@nio:/tmp$ cat file.csv
2014-08-21 18:06:26,A,B,12345,123,C,1232,26/08/14 18:07

akshay@nio:/tmp$ cat date_format.awk
function fmt(v,reverse){

	split(v,dt,"[-/ :]")	
	str=dt[1]" "dt[2]" "dt[3]" "dt[4]" "dt[5]" "dt[6]
	
	if(reverse)
	{
		dt[3] += (dt[3] >=0 && dt[3] <=69) ? 2000 : (dt[3]>=70 && dt[3] <= 99) ? 1900 : 0

		str = dt[3]" "dt[2]" "dt[1]" "dt[4]" "dt[5]" " ( length(dt[6])?dt[6]:0 )
	}

	return strftime("%d/%m/%Y %H:%m",mktime(str))
}
{
	$1 = fmt($1) 
	$8 = fmt($8,1)
}1

akshay@nio:/tmp$ awk -vFS="," -f date_format.awk file.csv
21/08/2014 18:08 A B 12345 123 C 1232 26/08/2014 18:08

sed -r "s/^([0-9]{4})-([0-9]{2})-([0-9]{2}) (.....)...(,.*,)([0-9]{2})\/([0-9]{2})/\2-\3-\1 \4\5\7\/\6/"

./csvsplit2.ksh[6]: : bad substitution