Shell Programming and Scripting

Target_RECRD_layout
{
    ABC_ID EN NOTNULLABLE,
    ABC_COUNTRY CHARACTER ENCODING ASCII NOTNULLABLE,
    FILLER1 CHARACTER ENCODING ASCII NOTNULLABLE,
    ABC_SOURCE CHARACTER ENCODING ASCII NOTNULLABLE,
    ABC_SOURCE_NUM EN NOTNULLABLE,
    FILLER2 CHARACTER ENCODING ASCII NOTNULLABLE,
    ABC_CODE EN NOTNULLABLE,
    ABC_CODE_ALPHA CHARACTER ENCODING ASCII NOTNULLABLE,
    ABC_DATA CHARACTER ENCODING ASCII NOTNULLABLE,
    ABC_DATA_ALPHA CHARACTER ENCODING ASCII NOTNULLABLE
   }

 awk '(NR>1 && $0 !~ /\{/ && $0 !~ /\}/){if(NF){A[++o]=$1}} END{print "Column_Number" OFS "Column_Name";for(i=1;i<=o;i++){print i OFS A[i]}}' Input_file

awk '
       (NR>1 && $0 !~ /\{/ && $0 !~ /\}/){
                                          if(NF)
                                         {
                                          A[++o]=$1
                                         }
                                         }
                                      END{
                                          print "Column_Number" OFS "Column_Name";
                        for(i=1;i<=o;i++){
                                          print i OFS A[i]
                                         }
                                         }
    ' Input_file

1 ABC_ID
2 ABC_COUNTRY
3 FILLER1
4 ABC_SOURCE
5 ABC_SOURCE_NUM
6 FILLER2
7 ABC_CODE
8 ABC_CODE_ALPHA
9 ABC_DATA
10 ABC_DATA_ALPHA

 awk '(NR>1 && $0 !~ /\{/ && $0 !~ /\}/){if(NF){A++}} END{print A}'  Input_file
 10

awk 'NF>1{CNT++} END {print CNT}' file
10

awk 'NF>1{CNT++} END {print CNT}' file

Column_Number Column_Name
1 Target_RECRD_layout
2 ABC_ID
3 ABC_COUNTRY
4 FILLER1
5 ABC_SOURCE
6 ABC_SOURCE_NUM
7 FILLER2
8 ABC_CODE
9 ABC_CODE_ALPHA
10 ABC_DATA
11 ABC_DATA_ALPHA

 awk '                                                                               
       (NR>1 && $0 !~ /\{/ && $0 !~ /\}/){                                             ###### Checking condition if line number is greater than 1 and line doesn't have characters { AND } in it then perform below.
                                          if(NF)                                       ###### If number of fields are NOT empty.
                                         {
                                          A[++o]=$1                                    ###### Creating an array named A whose index is a variable whose value is increasing each time this operation is called.
                                         }
                                         }
                                      END{
                                          print "Column_Number" OFS "Column_Name";     ###### printing the strings (which you doesn't want in output) Column_Number and Column_Name
                        for(i=1;i<=o;i++){                                             ###### Initating a for loop which will run from variab;e i's value from 1 to till o's value.
                                          print i OFS A[i]                             ###### printing the index of array a AND value of A by A[i]
                                         }
                                         }
    ' Input_file                                                                       ###### mentioning input_file name here.
  
  
 
awk '(NR>1 && $0 !~ /\{/ && $0 !~ /\}/){           ###### Checking condition if line number is greater than 1 and line doesn't contain strings { AND } in them.
if(NF){                                            ###### Checking condition if number of field is NOT NULL.
A++}}                                              ###### Incrementing a variable named A's value each time above condition is TRUE.
END{print A}'                                      ###### At last printing the value of variable A, which will provide the columns count in input file.
Input_file                                         ###### mentioning input_file name here.

awk 'NF>1                                          ###### If Number of fields are greater than 1 in a line then perform following actions.
{CNT++}                                            ###### Incrementing a variable named CNT's value each time above condition is TRUE.
END {print CNT}'                                   ###### At last printing the value of variable CNT, which will provide the columns count in input file.
file                                               ###### mentioning input_file name here.