Options

FILTER (SETRANGE - SETFILTER)

andy76andy76 Member Posts: 616
Hello,

I have to create a particular filter.
Suppose I have to filter Alphabetic data (A .... -> Z) but so

SETRANGE (MyField, 'C', 'G') + SETRANGE(MyField, 'R')

So a simple range but also a value external to the range.

How can I solve this? #-o

Thank you very much

Answers

  • Options
    bbrownbbrown Member Posts: 3,268
    SETFILTER('Your FIELD', '%1..%2|%3', 'C', 'G', 'R');
    There are no bugs - only undocumented features.
  • Options
    andy76andy76 Member Posts: 616
    Thank you very much.
    It was so simple ...
  • Options
    Johannes_NielsenJohannes_Nielsen Member Posts: 206
    Remember to mark the thread as Solved :mrgreen:
    Best regards / Venlig hilsen
    Johannes Sebastian
    MB7-840,MB7-841
Sign In or Register to comment.