Hey just wondering if someone can tell me the right line of code to use.
Basically my product codes for an ecommerce site all begin with three letters and an '/' sign
e.g ABC/1234 would map to the brand ABC in my excell file(product upload mapping)
This was done as the csv generating from my POS database wasnt generating brand names.
See line in code it basically says that after the first three letters that are separated with the '/' symbol they will map the brand name right.
Now we have changed 2 products to contain a '-' symbol instead of '/'
ABC-1234 instead of ABC/1234.
I need the right sql code to say anything with a - is added just like the / sign.