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
You can also use a filter to check brackets in the name, thereby simplifying the 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)