Be sure to review our Idea Submission Guidelines for more information!
Submission Guidelines
Example Data: | |||||
MJE Text | Ref Fld 1 | Ref Fld 2 | Ref Fld 3 | Date | NTID |
Accrual | MJE Load | 11/1/2019 | DAVET | ||
Fx Reval | Accrual | 12/2/2019 | MOLLYI | ||
Acc | 3/4/2019 | BOBH | |||
Forex Fx | CCRUAL | 7/9/2019 | GREGA | ||
FASB | 8/5/2019 | BOT7 | |||
Tax | 10/6/2019 | BOT88 |
I want to use contains to search multiple strings and "IN" for multiple targets within the same formula.
IF Contains(([MJE Text]+[Ref Fld 1]+[Ref Fld 2]+[Ref Fld 3) IN("Accrual","Acc","CCRUAL")) THEN "Accrual" ELSE "" ENDIF
Result would be: | ||||||
MJE Text | Ref Fld 1 | Ref Fld 2 | Ref Fld 3 | Date | NTID | Group |
Accrual | MJE Load | 11/1/2019 | DAVET | Accrual | ||
Fx Reval | Accrual | 12/2/2019 | MOLLYI | Accrual | ||
Acc | 3/4/2019 | BOBH | Accrual | |||
Forex Fx | CCRUAL | 7/9/2019 | GREGA | Accrual |
Can this be developed?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.