Special Chars in Qlik sense

Sush123 — Thu, 31 Mar 2022 05:52:01 GMT

Hi All,

Need a quick help here for finding out special characters in a string .

I need to find if there are presence of those special chars like '/*', '--' , '\\' which are combination of two chars.

I am using the below script :

Keepchar( Col, '/*--\\ ') > 0 , but Qlik is not able to identify multiple chars .

And if i use Wildmatch( Col, '*--*', '*/**') > 0 , here also /* is not able identify in Qlik.

Ex:

ABC8/*76RD

12--DRF567

123-BHYR-&YT

HYTR\\78RET

Could anyone have any ideas here.

Re: Special Chars in Qlik sense

Miguel_Angel_Baeyens — Thu, 31 Mar 2022 06:39:20 GMT

I would probably use Match(), something like (not tested)

=If(Match(Col, '/', '*', '\'), doiftrue, doiffalse)

Further reference:
https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFunctions/match.htm