0

Filtering on part of a string

Jet Reports Historic Posts

July 14, 2017 11:16

None

Follow

Hello all,

I'm a newbie to jet reporting although I have done some reporting using Crystal Reports and SSRS over the years.

I need to filter based on the last 2 characters of a string. We flag something as obsolete by appending XX to the name or description. I want to create a Jet Report to list obsolete items. So my filter needs to be the Excel equivalent of Right(Trim(field), 2).

Any ideas or suggestions would be welcomed.

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts July 17, 2017 15:07

  Hi -
  
  Yes, that can be done with a function similar to this:
  
  =NL("Rows","Item","No.","=Right(NF(,""Description""),2)","XX")

• 0
  
  Jet Reports Historic Posts July 20, 2017 17:01

  I've learned since that I could have just filtered on "Description", "*XX" to get everything ending in XX.