topic Regular Expressions RegExp in QlikView

Regular Expressions RegExp

rbecher — Thu, 23 Apr 2009 19:28:45 GMT

Hi,

we're using a VBScript Function to test regular expressions (similar to the cookbook example) in our load script.

Sometimes QV crashes with general script error, not depending on data or pattern. Is there an issue with VBScript stability in QV?

How are your experiences with regexp in QV?

Ralf

Regular Expressions RegExp

Oleg_Troyansky — Thu, 23 Apr 2009 19:51:49 GMT

Ralf,

I haven't had any experience with regexp, but in general, I noticed that macro stability is far worse than regular QlikView/QlikView script's stability. I also noticed that VBScript functions slow down the load process a lot, especially noticeable on large data sets.

I used to have a lot of fun with macros (as you could say, looking at my "QlikView Explorer" and "Colors" samples), but lately I'm trying to stay away as much as possible.

just my two cents...

Oleg

Regular Expressions RegExp

rbecher — Thu, 23 Apr 2009 20:21:22 GMT

Oleg,

I know all this. But it's mostly the VBScript call, not the function itself is slowing down the script process (but also limit it to single cpu processing).

In this case we can live with the lower performance. We need it for our data profiling app.

Would be nice if regexp could become a QV script function. How else you could do things like this?

Ralf

Regular Expressions RegExp

rwunderlich — Fri, 24 Apr 2009 01:42:21 GMT

Hi Ralf,

I use RegExp a fair bit in script macros and haven't encountered any stability problems.

I do encounter stability problems when using macros in the UI and only use them there as a last resort. Using macros as script functions, I haven't encountered any problems.

-Rob