Eliminate endings from part numbers

[infinitysales]

Hi,

I am trying to find a way to eliminate endings off of part numbers.

Below are the list of endings that I need to be eliminated from an extremely long list of variant part numbert. This list below may need to have additional endings added, but nothing will be removed. Please see attachment for example of part numbers that need below endings eliminated. Thanks!

R
T
G4
E4
RG4
RE4
TG4
TE4
G6
E6
RG6
RE6
TG6
TE6
/2K5
/3K
/250
/500