2022-04-24
14710
35
8315
1 minutes.


How to get the article indicated in the name in brackets

Often you need to get the manufacturer's SKU, which is indicated in brackets in the name of the product, you can use a formula for this, which checks for the presence of two brackets in the "Name" field and if they are, the value in them is taken.
CASE
WHEN {Price list: Name} LIKE '%(%' AND {Price list: Name} LIKE '%)%'
THEN SUBSTRING_INDEX(SUBSTRING_INDEX({Price list: Name},'(',-1),')',1)
ELSE '' END
elbuz etrade jumper pricelist formula

You can also use a filter to check brackets in the name, thereby simplifying the formula
elbuz etrade jumper pricelist formula

How to get the last word in the name of the product, let's say that the article of the product is indicated there
SUBSTRING_INDEX({Price list: Name},' ',-1)


Site content


 

Copywriter ElbuzGroup


Save a link to this article


Next