Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using Regex in the Qlik Sense Desktop

Hi Guys,

I have been trying to use Regex (besides the wild match, mix math etc functions).

So after some researching I found out this Qlik Thread: Regular expression [A-Z] *

However, I am not clear with the part that says: http://prntscr.com/iisuan

Queries:

> Where to put the part that deals with Regex Function Definition (article says "VBScript code to be put in Macro Editor")

> Is this capability only restricted to Qlik View coz the above mentioned thread is in that thread?

I am new to Qlik would really appreciate any help or insight on this.

4 Replies
rwunderlich
MVP
MVP

The Macro facility is only available in QlikView.

-Rob

zebhashmi
Specialist
Specialist

it could be SUB, End SUB in the script

rwunderlich
MVP
MVP

SUB/ENDSUB defines a set of Qlik Script statements. In this case, the OP wants to use VBScript to implement RexExp.

Someone out there somewhere I'm sure is building a Server Side Extension for RegExp support.

-Rob

simonaubert
Partner - Specialist II
Partner - Specialist II

Hello,

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

Best regards,

Simon

Bi Consultant (Dataviz & Dataprep) @ Business & Decision