Formula to trim a particular part of a field value

CASE WHEN RTRIM(REGEXP_SUBSTR({class},'[^:]*’)) IN (‘Accessory’, ‘Parts’) THEN 1 ELSE 0 END

RTRIM(REGEXP_SUBSTR({‌altname},'[^:]*’)) , instead of altname give the field that you want to trim