Appropriate function?
I have a lookup which produced 200 matches (180 unmatched).eg
G_100-01_LS Match
G_101-01_LS Match
G_102-01_LS Match
G_101-01_MN No Match
G_102-01_MN No Match
G_101-01_PV No Match
G_102-01_PV No Match
I would like a function that would allocate
G_101-01_MN, G_102-01_MN
G_101-01_PV, G_102-01_PV
as partial matches based on the G_101-01 and G_102-01 prefixes. Can this be
done?
Also would this function act on the original lookup list or on the resulting
list as above?
Thanks
Hilton
|