mahir_data
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
idINT
raw_nameTEXT

Example input

products