easyPadini · text
Clean up messy size codes
Size codes have been entered by hand across stores, so the same size shows up with stray spaces and inconsistent capitalisation — " xl ", "Xl" and "XL" are all meant to be the same size.
Tidy them up: strip the surrounding whitespace and convert to upper case.
Return sku and the cleaned value as size_code.
Schema
▸stock
| sku | TEXT |
| size_code | TEXT |
Example input
▸stock
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.