I'm working on a project for work where I need to turn SKU numbers (just a string of numbers and characters) into a regular word. For example, if the cell contains "sahara" (full cell is jmackey-sahara-XL), I want to have a corresponding adjacent column that says "Sahara." There isn't a consistent length to the beginning or ending of the SKU number, it varies for each product (upwards of 15 products). I have included an example list to show what I want to do. Is there any way to do this?
[TABLE="width: 500"]
<tbody>[TR]
[TD]jmackey-sahara-L/XL[/TD]
[TD]Sahara[/TD]
[TD]L/XL[/TD]
[/TR]
[TR]
[TD]jmackey-stealthy-S/M[/TD]
[TD]Stealthy[/TD]
[TD]S/M
[/TD]
[/TR]
[TR]
[TD]jmackey-recon-S/M[/TD]
[TD]Recon[/TD]
[TD]S/M[/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD]jmackey-sahara-L/XL[/TD]
[TD]Sahara[/TD]
[TD]L/XL[/TD]
[/TR]
[TR]
[TD]jmackey-stealthy-S/M[/TD]
[TD]Stealthy[/TD]
[TD]S/M
[/TD]
[/TR]
[TR]
[TD]jmackey-recon-S/M[/TD]
[TD]Recon[/TD]
[TD]S/M[/TD]
[/TR]
</tbody>[/TABLE]