Exclude values

[#1]

Hi,

I have a list of values in a table and a table containing purchases. The connection between these two tables is the invoice number. Now I want to show invoice numbers connected to values except for some values.

One invoice number can have many values.

Say I have this;

invoice_number;value

100200;[1x,2x,3x]
200300,[2x,4x,5y]

The script that I want to write is: set true if invoice_number has the value 2x but not 3x. In this case invoice_number 1 is false and invoice_number 2 is true.

Can this be written with a if-statement or a set analysis?

[#2]

I would user regular expression for your case; you can see the following post:

http://www.qlikfix.com/2010/10/18/regular-expressions-in-the-load-script/

I will try to come back later with an example.

Otherwise you can you the index function, but the code will not be as straight forward

[#3]

Thanks, I would appreciate an example. I've looked on the link you sent me but what I understand this regex is not a function within Qlikview but a function that I need to create in VBscript?