Now I want to merge these two files in such a way that the output file will look like this:
Here the last field i.e. the Birth Date from input file2 is merged to input file1. The key for both the input files is 5 chars from 4th position + 5chars from 9th position. eg. ABCDE(NAME) + 12345(NUMBER).
In cases where input file1 has a record without a match in input file2, and where input file2 has a record without a match in input file1 then we can write spaces for data that is missing in any file. E.g. if Input1 has a record and no matching record in Input2 then we can write spaces in place of Birth Date.
Note: I have added the seperator just to seperate the data. There is no seperator in the actual file.