Calling all Geniuses,

Is it possible to trim down something like this, I have over 4 thousand of
these, they are SKU's with case pack size

9811HAC-6, I need it to be just 9811, I need it to strip the HAC-6
5465PAD-12, I need it to be just 5465, I need it to strip the PAD-12
and so on.

Regards,