I'm looking for a way to remove words found in one field that's found in another.
Brand Name: 3M
Description: 3M Yellow Highlighter
Desired Result: Yellow Highlighter
I've seen and tried Trim to remove the brand name from the field, however, it only returns the brand.
Please help, I'm fairly new at creating FileMaker databases.
In excel if I wanted to do this I would use a trim/substitute formula, is there something similar to this that's available?