Columns into rows

Shell Programming and Scripting
1

Hi,

Let me know how to achieve the below requirment

Input:

     BEGIN DSSUBRECORD
         Name "DOC_NO_2"
         SqlType "-5"
         Precision "0"
         Scale "0"
         Nullable "0"
      END DSSUBRECORD
      BEGIN DSSUBRECORD
         Name "FROM_LOC"
         SqlType "-5"
         Precision "0"
         Scale "0"
         Nullable "0"
      END DSSUBRECORD

Output

Name "DOC_NO_2" SqlType "-5" Precision "0" Scale "0 Nullable "0"
Name "FROM_LOC" SqlType "-5" Precision "0" Scale "0" Nullable "0"

Regards,
Ram

2

Try this:

awk '
{$1=$1} 
/Name/{s=$0; next}
/END/{print s;s=""}
{s=s FS $0}' file