Qlik Community

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Native Regex support for Qlik Sense

simonaubert
Partner
Partner

Native Regex support for Qlik Sense

Hello,

Well, every other products on the market support regex expression, not Qlik. Qlikview offers a turnaround based on macros.

According to wikipedia https://en.wikipedia.org/wiki/Regular_expression

A regular expression, regex or regexp[1] (sometimes called a rational expression)[2][3] is a sequence of characters that define a search pattern. Usually such patterns are used by string searching algorithms for "find" or "find and replace" operations on strings, or for input validation. It is a technique developed in theoretical computer science and formal language theory.

 

Best regards,

Simon

Bi Consultant (Dataviz & Dataprep) @ Business & Decision
Tags (3)
5 Comments
marc_behrens
Partner
Partner

Would be nice to use for URLs / SEO

Spivey
Partner
Partner

This would be a hugely useful function! Data validation, especially, would become much easier with regex.

pritamdeb
Partner
Partner

Would love to have native support for RegExp. At this moment, we are using QlikView RegExp macros to process the data and create QVD which are being consumed by Qlik Sense. The existing RegEx connector seems clunky and ungainly.

Jeffrey_Goldberg
Employee
Employee

Hi there, it's not currently planned, but I would like to understand better. RegEx in load script? RegEx in expression editor? Are you looking for the ability to add a known pattern or do you expect a built-in pattern matcher like https://regex101.com/

I concur using a web connector is not ideal.

Status changed to: Open - Not Planned
simonaubert
Partner
Partner

Hello @Jeffrey_Goldberg 

Regex in both load and expression. In load script, I expect it written by hand and in expression with a little wizard such as regex101 or the wizard for set analysis.

Best regards,

Simon