Copy and Paste the following formula using your data where necessary.
Description:
Take the 11th through the 17th character of "Product (REF)"
{Product (REF)}.substring(10,17)
Click to copy
Description:
Take the suffix of a string beginning from the last instance of a character.
{String Field}.substring({String Field}.lastIndexOf("Character Reference") + 1, {String Field}.length())
Click to copy