How to convert Excel Search logic into QlikView logic

[vengadeshpalani]

Hi All

in excel i have use this formula, how to convert into qlikview logic

=IF(ISNUMBER(SEARCH("outside",A2)),"Outside","Inside")

PFA

[sunny_talwar · Accepted solution]

May be this

If(WildMatch(Input, '*Outside*'), 'Outside', 'Inside') as Output

[Anil_Babu_Samineni]

Or This?

If(SubStringCount(Input, 'OUTSIDE'),'Outside','Inside') as Output