UNIX for Dummies Questions & Answers

Dear Friends,
I have a file as under :

Code:

     +++ ME 12-06-13 18:16:20 
A  RED FEW AND ROW1 1MN FEL  AS
   HI FI BV      LR     TS    HR    ES    MR    
       *  0      13296   0    120   1     15
   KS  RR   
   10   0

      +++ ME 12-06-13 18:26:20 
A  RED FEW AND ROW2 1MN FEL  AS
   HI FI BV      LR     TS    HR    ES    MR
       *  1      13296   0    120   0     15
   KS  RR
   10   0

I am required to get the output as under:

Code:

 NAME	   DATE	   TIME    HI FI BV      LR     TS    HR    ES    MR   KS  RR
   ROW1 12-06-13 18:16:20     *  0      13296    0    120   1     15   10   0
   ROW2 12-06-13 18:26:20     *  1      13296    0    120   0     15   10   0

I am totally out of thought how it can be done.

Please help. Thanks in Advance.

Is your file already tab-delimited?
Here a straight bit of code:

Code:

#!/usr/bin/awk -f

BEGIN{
	OFS="| ";print "NAME| DATE| TIME| HI| FI| BV| LR| TS| HR| ES| MR| KS| RR"
}
/\+\+\+/{
	s=$3 OFS $4
	getline
	s=$5 OFS s
	getline;getline; gsub("\t",OFS); s=s $0
	getline;getline; gsub("\t",OFS); s=s $0
	print s
}

Usage : save this code with a filename, set +x flag; then use:~/unix.com$ filename your_data_file | column -ts'|'

Perfect!!!!!!

$ cat e1f | awk 'BEGIN {OFS="| ";print "NAME| DATE| TIME| HI| FI| BV| LR| TS| HR| ES| MR| KS| RR"} /\+\+\+/ {s=$3 OFS $4;getline;s=$5 OFS s;getline;getline;gsub("\t",OFS);s=s $0;print s}'
NAME| DATE| TIME| HI| FI| BV| LR| TS| HR| ES| MR| KS| RR
ROW1| 12-06-13| 18:16:20 * 0 13296 0 120 1 15
ROW2| 12-06-13| 18:26:20 * 1 13296 0 120 0 15

$ cat e1f | awk 'BEGIN {OFS="| ";print "NAME| DATE| TIME| HI| FI| BV| LR| TS| HR| ES| MR| KS| RR"} /\+\+\+/ {s=$3 OFS $4;getline;s=$5 OFS s;getline;getline;gsub ("\n",OFS);s=s $0;print s}'
NAME| DATE| TIME| HI| FI| BV| LR| TS| HR| ES| MR| KS| RR
ROW1| 12-06-13| 18:16:20 * 0 13296 0 120 1 15
ROW2| 12-06-13| 18:26:20 * 1 13296 0 120 0 15

$ cat e1f | awk 'BEGIN {OFS="| ";print "NAME| DATE| TIME| HI| FI| BV| LR| TS| HR| ES| MR| KS| RR"} /\+\+\+/ {s=$3 OFS $4;getline;s=$5 OFS s;getline;getline;gsub ("",OFS);s=s $0;print s}'
NAME| DATE| TIME| HI| FI| BV| LR| TS| HR| ES| MR| KS| RR
ROW1| 12-06-13| 18:16:20| | | | | | | *| | | 0| | | | | | | 1| 3| 2| 9| 6| | | | |
0| | | | | 1| 2| 0| | | | 1| | | | | | 1| 5|
ROW2| 12-06-13| 18:26:20| | | | | | | *| | | 1| | | | | | | 1| 3| 2| 9| 6| | | | |
0| | | | | 1| 2| 0| | | | 0| | | | | | 1| 5|

$ cat e1f | awk 'BEGIN {OFS="| ";print "NAME| DATE| TIME| HI| FI| BV| LR| TS| HR| ES| MR| KS| RR"} /\+\+\+/ {s=$3 OFS $4;getline;s=$5 OFS s;getline;getline;gsub (" ",OFS);s=s $0;print s}'
NAME| DATE| TIME| HI| FI| BV| LR| TS| HR| ES| MR| KS| RR
ROW1| 12-06-13| 18:16:20| | | | | | *| | 0| | | | | | 13296| | | | 0| | | | 120| | | 1| | | | | 15
ROW2| 12-06-13| 18:26:20| | | | | | *| | 1| | | | | | 13296| | | | 0| | | | 120| | | 0| | | | | 15

gsub changes the output format completely. Is this normal. How to put single delimiter | after each field.