easyZalora · text
Clean up messy product names
A supplier feed imported product names with stray whitespace and inconsistent casing. For each product, return:
- id
- clean_name: the name with leading/trailing whitespace removed
- brand: the first word of the cleaned name, in uppercase
Assume the brand is always the first space-separated word.
Schema
▸products
| id | INT |
| raw_name | TEXT |
Example input
▸products