string - get specific word from one column in select query

Question

I have column in table with below data and I would like to get a single word from this string excluding special character and Number.

Below is my table data 90% Polyester- Polyurethane coated, 8% Cotton - Polyurethane coated, 2% Viscose - Polyurethane coated

Output needed enter image description here Polyester- Polyurethane coated Cotton - Polyurethane coated Viscose - Polyurethane coated

After getting this output have to combine the same after mapping it to another tables data.

标签： stringsplitmapping