Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to search for a word in a string and if it contains, do something.
is there any equivalent operator in Qlikview similar to 'LIKE' operator of Oracle?
if($(Path) like 'TEST') then
store $(PATH)/test.qvd;
end
There is a LIKE string operator in QlikView, please search the Help for string operators.
if(match($(Path), 'TEST'), ..., ...)
from online help
match( str, expr1 [ , expr2,...exprN ] )
The match function performs a case sensitive comparison.
mixmatch( str, expr1 [ , expr2,...exprN ] )
The mixmatch function performs a case insensitive comparison.
wildmatch( str, expr1 [ , expr2,...exprN ] )
The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters ( * and ?) in the comparison strings.
Example:
wildmatch( M, 'ja*','fe?','mar')
returns 1 if M = January
returns 2 if M = fex
Thank you. I just solved it using INDEX() function
IF index('$(Path)','TEST') > 0 THEN
STORE Cust INTO $(Path)Cust.qvd ;
END IF