All customers EXCEPT..

yuppicide
yuppicide Member Posts: 410
edited 2009-12-15 in Navision Attain
Is there a way to filter customers to not include any with a + in their name?

I've tried something like <>*+* or <>*"+"* with no luck.

Comments

  • Savatage
    Savatage Member Posts: 7,142
    Do they all have a + because they have something else in common?

    Like a certain type of customer or something. Or was it a lasy thing, like someone not wanting to enter "and"?

    Do the + all occur at the same place? does it start with a + or is it the 4th character, for example?

    Your on Native DB right & No Dev License so I would think of a new field or new way if you need to "Mark" these customers in some way.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • fverkel
    fverkel Member Posts: 66
    Mark all records (Ctrl+A, Ctrl+F1).
    Filter using *+*, then unmark these records (Ctrl+A, Ctrl+F1).
    Remove the filter, then use Marked only.

    You can use this method in C/AL-code.
    On large tables this could cause performance problems.
    Keep It Simple and Stupid (KISS), but never oversimplify.
  • yuppicide
    yuppicide Member Posts: 410
    That worked great. Although I think in the second instruction you meant CTRL+F1 first then CTRL+A. Thanks!

Categories