Shell Programming and Scripting

hi all, iam new to awk & sed cmd and appreacite help from all the script expert from this forum, i have a file like below:

Fri Aug 01 00:01:19 2008
NAS-IP-Address = 172.16.160.1
Class = "P1-SHT-AAA01;1217116976;70999"
Calling-Station-Id = "00-11-FB-01-03-06"
Acct-Status-Type = Start
Acct-Session-Id = "31908b485a370000"
Framed-IP-Address = 172.16.160.10
BS-ID = 000012A00433
User-Name = "user1"

Fri Aug 01 00:02:02 2008
NAS-IP-Address = 172.16.160.1
Class = "P1-SHT-AAA01;1217116976;71005"
Calling-Station-Id = "00-11-FB-01-03-06"
Acct-Status-Type = Stop
Acct-Session-Id = "31908b485d370000"
Framed-IP-Address = 172.16.160.20
BS-ID = 000012A00413
User-Name = "user2"

Fri Aug 01 00:02:02 2008
NAS-IP-Address = 172.16.160.1
Class = "P1-SHT-AAA01;1217116976;71005"
Calling-Station-Id = "00-11-FB-01-03-06"
Acct-Status-Type = Stop
Acct-Session-Id = "31908b485d370000"
Framed-IP-Address = 172.16.160.20
BS-ID = 000012A00413
User-Name = "user3"

this only 3 records from the file but it actually have more than 5-7k records. and i need import this record into mysql server which mean I need to convert this record to csv format (1 record per line) like below:

2008-08-01;172.16.160.1;P1-SHT-AAA01;1217116976;71005;00-11-FB-01-03-06;Stop;31908b485d370000; 172.16.160.20;000012A00413;user3


thanks in advance.

One approch:

Code:

awk -F= '!/^$/{if ($0 !~ /=/) {str="date -d \""$0"\" \"+%d-%m-%Y\""; val=system(str); } else {print $2;} }'  < filename | xargs -n9 | tr " " ";"

dennis.jasob, you are genuis, thanks alot, let me try and see how is the output.

dennis,

just tried your code and I almost there, only have some problem, the ouput

01-08-2008;172.16.160.1;P1-SHT-AAA01;1217116976;70999;00-1F-FB-00-02-26;Start;31908b485a370000;120.140.0.54;000012A00433;1001100551@P1
24-11-2008;01-08-2008;172.16.160.1;P1-SHT-AAA01;1217116976;71005;00-1F-FB-00-06-61;Start;31908b485d370000;120.140.0.184;000012A00413
1001101634@P1;01-08-2008;172.16.160.1;P1-SHT-AAA01;1217116976;70999;00-1F-FB-00-02-26;Start;31908b485a370000;120.140.0.54;000012A00433
1001100551@P1;24-11-2008;01-08-2008;172.16.160.1;P1-SHT-AAA01;1217116976;71005;00-1F-FB-00-06-61;Start;31908b485d370000;120.140.0.184
000012A00413;1001101634@P1

notice the date keep repeating on the next lines ? any solution for this ? thanks

This is because of the blank lines. Try this:

Code:

awk -F= '!/^ /{if ($0 !~ /=/) {str="date -d \""$0"\" \"+%d-%m-%Y\""; val=system(str); } else {print $2;} }'  < filename  | xargs -n9 | tr " " ";"

still the same.

perl:

Code:

%hash=('Jan','01','Feb','02','Mar','03','Aug','08'); # add all the enumerate value 
$/="\n\n";
open FH,"<d:/perlscript/a.txt";
@arr=<FH>;
foreach(@arr){
	my @temp=split("\n",$_);
	map{s/.*=//;s/\"//g;} @temp;
	my @t=split(" ",$temp[0]);
	print $t[4],"-",$hash{$t[1]},"-",$t[2],";";
	print $_,";" foreach (@temp[1..$#temp-3]);
	print "\n"; 
	print $_,";" foreach (@temp[$#temp-2..$#temp]);
	print "\n";
}