I've two flat files similar similar in properties say file A and file B
File A
12345 6789
78787 6789
AAAAA
File B
77777777777777777777777777
88888888888888888888888888
I want to insert all records from File B to file A when you find character 'A' in coulmn number 1 of file A (before the record AAAA ) and get it in a new file
Output :
12345 6789
78787 6789
77777777777777777777777777
88888888888888888888888888
AAAAA
Inserting before record AAAA is a bit tricky.Is it possible