Shell Programming and Scripting

awk -F "[=;]" '/DEPTH/{n=split($2,DP,",")}
/TEMPERATURE/{s=$2;getline;s=s""$1;m=split(s,TM,",")}
/SALINITY/{s=$2;getline;s=s""$1;split(s,SL,",")}END{print "DEPTH","TEMPERATURE","SALINITY";
for(i=1;i<=m;i++){print DP[i],TM[i],SL[i]}}' F1.txt

akshay@akshay-Vostro-460:~/NCL/Untitled Folder$ ./new.sh
DEPTH TEMPERATURE SALINITY
 1  28.25  36.42
 5  28.26  36.42
 10  28.23  36.43
 15  28.22  36.43
 20  28.2  36.42
 25  28.19  36.43
 30  28.18  36.43
 35  28.18  36.43
 40  28.18  36.44
 45    
akshay@akshay-Vostro-460:~/NCL/Untitled Folder$

for file in *.txt; do
awk -F "[=;]" '/DEPTH/{n=split($2,DP,",")}
/TEMPERATURE/{s=$2;getline;s=s""$1;m=split(s,TM,",")}
/SALINITY/{s=$2;getline;s=s""$1;split(s,SL,",")}END{print "DEPTH","TEMPERATURE","SALINITY";
for(i=1;i<=m;i++){print DP[i],TM[i],SL[i]}}' $file > "out_"$file
done

for file in *.txt; do
awk -F "[=;]" '/DEPTH/{n=split($2,DP,",")}
/TEMPERATURE/{s=$2;getline;s=s""$1;m=split(s,TM,",")}
/SALINITY/{s=$2;getline;s=s""$1;split(s,SL,",")}END{print "DEPTH","TEMPERATURE","SALINITY";
for(i=1;i<=m;i++){print DP[i],TM[i],SL[i]}}' $file >> Output_file
done

awk  '{gsub (/[ ;{}]/,"")}
     /^DEPTH=/       {m=split($2, D, /,\n*/)}
     /^TEMPERATURE=/ {n=split($2, T, /,\n*/)}
     /^SALINITY=/    {o=split($2, S, /,\n*/)}
     END {for (i=1;i<=n; i++) print D[i],T[i],S[i]}
    ' FS="=" OFS="\t" RS= file
1     28.25    36.42
5     28.26    36.42
10    28.23    36.43
15    28.22    36.43
20    28.2     36.42
25    28.19    36.43
30    28.18    36.43
35    28.18    36.43
40    28.18    36.44
45    28.19    36.45
50    28.19    36.44