0

Jet function "Does not contain..."

Jet Reports Historic Posts

January 15, 2010 20:05

None

Follow

I need a little help with a "contains" or "does not contain" filter for my Jet Report. I am away of the "starts with" syntax *, but I have not found a way to adapt the wild card to a filter of "contains".

Does anyone have any solutions they can offer?

Thanks in advance!

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts January 18, 2010 14:28

  Have you tried the Jet Reports Help, or the Jet Reports Documentation that you may download from support.jetreport.com, or the manuals you got from your Jet Reports training course?
  
  Searching for Filter will you give a list of all the filter operators with some very nice examples, including "does not contain" which is "<>".

• 0
  
  Jet Reports Historic Posts January 20, 2010 13:00

  including "does not contain" which is "<>".

  
  This is the operator for UNEQUALS… You cannot do a 'does not contain' <>*X* because ? and * cannot be combined with < and/or >.
  
  <>B* INVALID for does not start with B.
  <>*E INVALID for does not end with B.
  
  You can however use NP array function to get the does not contain:
  
  =NL("Rows"; NP("Difference"; NL("AllUnique";"Customer";"No."); NL("AllUnique";"Customer";"No.";"Name";"B*") ) )
  Above gives you all unique customers from the first NL("AllUnique") that are not found in second NL("AllUnique"), so all customer not starting with B.