Qlik Community

QlikView Documents

Documents for QlikView related information.

How to use regular expressions

How to use regular expressions

- Do you need to find specific files in your file system easily to perform operations on them (e.g. backup, rename, etc.)?

- Do you need to select field values that contain complex substrings?

- Do you need to extract a list of source files from your QlikViev script?

- Do you need to search for specific text using complex rules, but you don't know how?


Why not use regular expressions?

Attachments
Comments
luciancotea
Valued Contributor

Very useful. Thanks!

0 Likes
Not applicable

I am tring to open it but i am getting a prblm because i am using personal edition,It is not accepting to open this QVW.Can any one help me.

0 Likes
MVP
MVP

Good post..

bouderbc
Contributor

Hello les experts ,

Contexte : Réappropriation d'une application QVW  existante 

Problème bloquant : Le développeur a utilisé dans son script la fonction Regex find  pour extraire des données >>>> Error in expression:
REGEXFIND is not a valid function

Exemple : RegExFind(Commentaire, '\d{2}-\d{2}-\d{2}-\d{2}-\d{2}', ';') as MOTS_INTERDITS

Le script bloque a chaque fois qu'il y'a ce genre de fonction , connaissez vous une fonction pouvant remplacer cette expression ou fonction .

Merci de votre retour !

Ali

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎08-27-2013 01:36 PM
Updated by: