Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sush123
Contributor III
Contributor III

Special Chars in Qlik sense

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.

Labels (1)
1 Reply
Miguel_Angel_Baeyens

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/Conditiona...