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