AnsweredAssumed Answered

Functions from Excel

Question asked by cschul on Mar 4, 2013
Latest reply on Mar 4, 2013 by philmodjunk

Title

Functions from Excel

Post

      

     This is the formula I'm using in Excel.

      

     =IF(SEARCH("Cat. #",AN2),LEFT(AN2,FIND("(Cat. #",AN2)-1)&""&MID(AN2,FIND("(Cat. #",AN2)+17,999),AN2)

     Is there anything similar to Search or the Find functions in excel in FileMaker Pro?

     I'm trying to figure out how to find a certain line of text in a field and remove it. The text has wildcards in it.

     I have found functions that may be able to help me, however it looks like they are for Advance only.

Outcomes