String search

[#1]

In our SQL table, we are importing unstructured notes in one column. I would like to search for 'key word' and surrounding 200 words around key word. Is it possible in Qliview?

[anbu1984]

Check Index(),Match() or WildMatch()

[robert_mika]

Could you attached your sample?

[sagarkharpude]

Hi,

example:

IF(WildMatch(AC_4,'*Intercompany*')=1 AND AC_4<>'Subcontracting cost - Other than Intercompany',mid(AC_4,index(AC_4,'-',2)+1,210)) as INTER_COMPNAY 

The match function performs a case sensitive comparison while wildmatch & mixmatch function performs a case insensitive comparison.

[#5 · Accepted solution]

Thank you that helps.

[sagarkharpude]

please mark the correct answer and close the thread.