this is a data example of what i am attempting to parse into columns. i have tried the substring, not working so well not standard positions on the values

(blank spaces)24W 529 22 132 110 123 -13 516 (one row of data)

3102 DENIM 8 99 0 213 213 0 213 312 (another row data)

66552266 green blue 77p 1111 2222 33333 (another row)