you should try whit the function replace, maybe its the solution for your problem.
I can see that your´s strings have a variable lenght, you should try to delimite each substring like you need.
select REPLACE('24W 529 22 132 110 123 -13 516',' ','')
select REPLACE('3102 DENIM 8 99 0 213 213 0 213 312',' ','')
select REPLACE('66552266 green blue 77p 1111 2222 33333',' ','')
See you