help with using a lookup table

Category: UNIX-Unix Beginner

help with using a lookup table

using aix 5.2, bourne and korn shell.

i have two flat text files. one is a main file and one is a lookup table that contains a number of letter codes and membership numbers as follows:

316707965egm01
315672908anm92

whenever one of these records from the lookup appears in the main file then it needs to be removed from the main file.

the problem is in the main file you will see 316707965 (membership number) in the first part of the file, like starting character 6 for 9 but egm01 (letter code) later on in the file starting char 909 for 5 with other data in between.

i have tried egrep but there doesn