idea Re: Native Regex support for Qlik Sense in Suggest an Idea

Native Regex support for Qlik Sense

simonaubert — Wed, 25 Nov 2020 15:12:24 GMT

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

Re: Native Regex support for Qlik Sense

marc_behrens — Mon, 14 Oct 2019 09:32:37 GMT

Would be nice to use for URLs / SEO

Re: Native Regex support for Qlik Sense

Spivey — Thu, 01 Oct 2020 16:49:44 GMT

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

Re: Native Regex support for Qlik Sense

pritamdeb — Tue, 27 Apr 2021 13:13:22 GMT

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.

Re: Native Regex support for Qlik Sense - Status changed to: Open - Not Planned

Jeffrey_Goldberg — Mon, 14 Jun 2021 18:04:59 GMT

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.

Re: Native Regex support for Qlik Sense

simonaubert — Tue, 29 Jun 2021 09:53:11 GMT

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

Re: Native Regex support for Qlik Sense

simonaubert — Wed, 23 Nov 2022 08:37:27 GMT

Hello @Jeffrey_Goldberg

This idea has now 43 votes, wich is not that bad. Have you changed your mind on that "non-planned"?

Best regards,

Simon

Re: Native Regex support for Qlik Sense

Code — Wed, 23 Nov 2022 14:53:47 GMT

44 votes!

RegEx in load script AND in expression editor, in View AND in Sense!

Re: Native Regex support for Qlik Sense

simonaubert — Wed, 23 Nov 2022 16:44:19 GMT

Hello @Code

Can you please click on the thumb icon beside the number of likes? Thats's how you vote 😉

Best regards,

Simon

Re: Native Regex support for Qlik Sense

PabloLabbeImaps — Fri, 03 Feb 2023 00:24:23 GMT

Hi @Jeffrey_Goldberg , still not planned ?

Re: Native Regex support for Qlik Sense

steeefan — Mon, 18 Dec 2023 06:06:23 GMT

*bump*

Re: Native Regex support for Qlik Sense

pjn12345 — Fri, 24 May 2024 05:14:45 GMT

Even Excel now has RegEx support 😢

Need this function in the loadscript please.

Re: Native Regex support for Qlik Sense - Status changed to: Closed - Archived

Meghann_MacDonald — Fri, 24 May 2024 14:55:01 GMT

I will merge this with a duplicate in the new portal so we can combine likes and votes there. And I'll add everyone as voters / subscribers. You can find the new idea in the portal:

Use regular expressions (Regex) in script load #309962

Visit https://community.qlik.com/t5/Ideation/ct-p/qlik-product-insight and click "Open Portal" to ensure you're logged in, and then search for #309962 or click this link: https://ideation.qlik.com/app/#/case/309962

Re: Native Regex support for Qlik Sense

NoNameFound — Thu, 18 Jul 2024 11:43:19 GMT

This feature would be really useful!