Lookup field values in two fixed format file in UNIX - not working

Shell Programming and Scripting
1

I have 2 fixed length files input#1 & input#2. I want to match the rows based on the value in position 37-50 in both files (pos 37-50 will have same value in both files).
If any matching record is found then cut the value against company code & Invoice number from input file #1 (position 99 until end of line).
The cut string (from Input #1) need to be appended at the end of the record/line.
Below is the code I tried (not working) and the input files & desired output. Please provide your advice.

awk '
NR==FNR && NF>1 {
    v=substr($0,37,14);
#print substr($0,37,14)
    next
}
NR==FNR && ( /Company Code/ OR /Invoice Number/ ) {
    sub(/Company Code/,"",$0);
    sub(/Invoice Number/,"",$0);
    a[v]=$0;
print $0
    next
}
(substr($0,37,14) in a) {
    print $0 a[substr($0,99)]
}' Input1.txt input2.txt input3.txt

Input #1

     612  1111111111201402120000       2     1  111  211 Due Date                             20140101                                612  1111111111201402120000       2     1  111  311 Company Code                         227                                     612  1111111111201402120000       2     1  111  411 Item Code                            12                                      612  1111111111201402120000       2     1  111  511 Invoice Number                       2014010                                 612  1111111111201402120000       2     2  111  611 Company Code                         214                                     612  1111111111201402120000       2     2  111  711 Item Code                            20                                      612  1111111111201402120000       2     2  111  811 Invoice Number                       3014010                                 612  1111111111201402120000       2     3  111  911 Due Date                             20140101                                612  1111111111201402120000       2     3  111  111 Invoice Number                       40140101                                612  1111111111201402120000       2     3  111  121 user code                            15563263636                             612  1111111111201402120000       2     3  111  131 Amount Due                           100000                                  612  111111111120140212000078978982123444  111  141 Due Date                             20140101                                  612  111111111120140212000078978982123444  111  151 Invoice Number                       50140101                                  612  111111111120140212000078978982123444  111  161 Amount Due                           008000

                          Input \#2

    510       77432201111010000       2     1        1ChK          100111000001    121000248           123456789            20111101.510.77432.20001C                              510       77432201111010000       2     1        2INv                                                                   20111101.510.77432.20001D                              510       77432201111010000       2     1        3INv                                                                   20111101.510.77432.20002D                              510       77432201111010000       2     1        4INv                                                                   20111101.510.77432.20003D                              510       77432201111010000       2     1        5INv                                                                   20111101.510.77432.20004D                              510       77432201111010000       2     2        1ChK          200111000002    121000248           123456789            20111101.510.77432.20002C                              510       77432201111010000       2     2        2INv                                                                   20111101.510.77432.20005D                              510       77432201111010000       2     2        3INv                                                                   20111101.510.77432.20006D                              510       77432201111010000       2     2        4INv                                                                   20111101.510.77432.20007D                              510       77432201111010000       2     2        5INv                                                                   20111101.510.77432.20008D                              510       77432201111010000       2     3        1ChK          300111000003    121000248           123456789            20111101.510.77432.20003C                              510       77432201111010000       2     3        2INv                                                                   20111101.510.77432.20009D                              510       77432201111010000       2     3        3INv                                                                   20111101.510.77432.20010D                              510       77432201111010000       2     3        4INv                                                                   20111101.510.77432.20011D                              510       77432201111010000       2     6        1ChK          600111000006    121000248           123456789            20111101.510.77432.20006C                              510       77432201111010000       2     6        2INv                                                                   20111101.510.77432.20021D                              510       77432201111010000       2     6        3INv                                                                   20111101.510.77432.20022D                              510       77432201111010000       2     6        4INv                                                                   20111101.510.77432.20023D                              510       77432201111010000       2     6        5INv                                                                   20111101.510.77432.20024D

                  Desired output:

     510       77432201111010000       2     1        1ChK          100111000001    121000248           123456789            20111101.510.77432.20001C   2272014010 (company & Inv # from input 1)                          510       77432201111010000       2     1        2INv                                                                   20111101.510.77432.20001D   2272014010                                                 510       77432201111010000       2     1        3INv                                                                   20111101.510.77432.20002D   2272014010                                                 510       77432201111010000       2     1        4INv                                                                   20111101.510.77432.20003D   (company & Inv # from input 1)                           510       77432201111010000       2     1        5INv                                                                   20111101.510.77432.20004D   (company & Inv # from input 1)                           510       77432201111010000       2     2        1ChK          200111000002    121000248           123456789            20111101.510.77432.20002C   (company & Inv # from input 1)                           510       77432201111010000       2     2        2INv                                                                   20111101.510.77432.20005D   (company & Inv # from input 1)                           510       77432201111010000       2     2        3INv                                                                   20111101.510.77432.20006D   (company & Inv # from input 1)                           510       77432201111010000       2     2        4INv                                                                   20111101.510.77432.20007D   (company & Inv # from input 1)                           510       77432201111010000       2     2        5INv                                                                   20111101.510.77432.20008D   (company & Inv # from input 1)                           510       77432201111010000       2     3        1ChK          300111000003    121000248           123456789            20111101.510.77432.20003C   (company & Inv # from input 1)                           510       77432201111010000       2     6        1ChK          600111000006    121000248           123456789            20111101.510.77432.20006C   <there is no matching record in input 1, this will be blank>                           510       77432201111010000       2     6        2INv                                                                   20111101.510.77432.20021D   <there is no matching record in input 1, this will be blank>                           510       77432201111010000       2     6        3INv                                                                   20111101.510.77432.20022D   <there is no matching record in input 1, this will be blank>                           510       77432201111010000       2     6        4INv                                                                   20111101.510.77432.20023D   <there is no matching record in input 1, this will be blank>                           510       77432201111010000       2     6        5INv                                                                   20111101.510.77432.20024D   <there is no matching record in input 1, this will be blank>
2

The input you provided is next to impossible to understand.
Can you paste it neatly? Also, extract at least one value which is in the range 37-50 for our reference.

--ahamed

3 
awk 'NR==FNR && NF>1 { v=substr($0,37,14);#print substr($0,37,14) next}NR==FNR && ( /Company Code/ OR /Invoice Number/ ) { sub(/Company Code/,"",$0); sub(/Invoice Number/,"",$0); a[v]=$0;print $0 next}(substr($0,37,14) in a) { print $0 a[substr($0,99)]}' Input1.txt input2.txt input3.txt

I am trying to format the output to put it here

4

Giving us your code again (this time with no line breaks) doesn't help.

Your code uses three input files. You have shown us two lines of data.

Please show us all THREE of your sample input files in a readable format with CODE tags.
Since both of your input files are extremely long single lines with no matches in the 14 characters starting in column 37 between those lines, we can't guess at what you're trying to do!