How cann I select ,as shown below, in a field with a lot of data the product MFE2.
Product
Result
08d3630 MFE2
MFE2
9999 DKKDP:F
Other
09d dddef MFE2
MFE2
I would like to create an IF-function. When in the field Product the data MFE2 appears, then I would like to see in the field Result, the value MFE2 and if not the value Other.