Unanswered: Shell script, data search, extract, and convert.
I have two input files, "filea", "fileb".
filea = a "key" file containing an eight character customer number string in the first column, plus the "^" indicating it's located at the beginning of "fileb" and the target customer number in the second column which the first customer number must be converted to for the records in "fileb".
fileb = a large data file containing addresses, where many addresses exist for single customers from "filea". The first eight characters within this file contain the data strings from "filea".
So, in summary I need to extract data from "fileb" using the key from the first column in filea, and replace the customer number for the extracted records with the data from the second column in "filea".
I suppose I need to use sed or awk or something but I don't know how to do this. I hope I explained this well enough.