AnsweredAssumed Answered

Removing Text from Secondary Field

Question asked by dlg2002 on Mar 22, 2017
Latest reply on Mar 22, 2017 by dlg2002

I'm looking for a way to remove words found in one field that's found in another.

 

Ex.

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?

 

Thanks,

Outcomes