Regular expression

[QlikSensor]

Hi,

I currently try to transfer some things I am doing in Knime regarding data prep to QlikSense directly. One regular expression I try to transfer is:

"^.*Str[0-9]{5}.*|^GRE.*|^C-[0-9]{6}.*|^0000.*|^476.*|^462.*|^467.*|^N[0-9]{6}.*")

I managed to transfer the first expression partly with this statement I used to grab a dimension:

=If([MyDimension] like 'Str*',[MyDimension])

But I didn't manage to transfer the first part (^) and the second part with [0-9]{5}.*

Are there any means here to transfer that and bake it into a dimension?

[QlikSensor]

As I understood it right, there is a matches operator (not to be confused with the "match" function). matches should work as the like-operator but I could use regular expressions. Saying this, I get the like-operator running (as you can see in my example above) but not the matches-operator.

[simonaubert]

Hello,

Yep, regular expressions are not supported by Qlik Sense, some use extension others dataprep solution, others sql... or deal with string functions to reproduce the regex match from scratch.

there is also this idea to have regex in Qlik:

 https://community.qlik.com/t5/Qlik-Sense-Enterprise-Ideas/Native-Regex-support-for-Qlik-Sense/idi-p/...

Why do you want to transfer it from knime to QS?