Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
MVP
MVP

Regular Expressions RegExp

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

3 Replies

Regular Expressions RegExp

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

MVP
MVP

Regular Expressions RegExp

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

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

Community Browser