0

Filtering with | and *

Jet Reports Historic Posts

August 12, 2009 01:18

None

Follow

Hi All,

I am new to the community but been using Jet Reports for 2 years.

I wanted to ask if anyone has used filter values separated by | (pipe) to indicate the beginning of the values in the database, example below:

D5 - A|B
D6 - =NL("rows","customer","name","name",$D$6&"*")

- this is to create a list of customers where the name starts with either A or B

not sure if the formula is correct, thanks for your help and comments.

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts August 12, 2009 09:27

  Your setup only shows A and B* the filter should be: A*|B*
  Try this:
  
  D4 = A|B
  D5 = NP("Join";NP("Split";$D$4;"|");"*|")&"*"
  D6 = NL("Rows","Customer","Name","Name",$D$5)

• 0
  
  Jet Reports Historic Posts August 13, 2009 02:40

  Thanks Sebastiaan, you're a legend…
  
  that works exactly the way I wanted - perfectly…
  
  great help…cheers :D