3 Replies Latest reply on Mar 22, 2017 12:35 PM by dlg2002

    Removing Text from Secondary Field

    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,