Functions from Excel
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.