Extract string after a delimiter like "/ " OpenOffice Calc
I don't use OpenOffice, but as the syntax is closed to Excel's, you can try the following formula to extract everything after the \
:
=RIGHT(Products.D2;LEN(Products.D2)-FIND("/";TRIM(Products.D2))-1)
OR
=TRIM(RIGHT(Products.D2;LEN(Products.D2)-FIND("/";TRIM(Products.D2))))