NAV Function/Filter to do string checking

Lalaka
Lalaka Member Posts: 32
edited 2012-02-13 in NAV/Navision Classic Client
Hi,
Is there anyway (function) to check if a character is included in a String.
Ex: I have an Item Number List containing millions of items. One item is FL222104,another is RM112200.
How can I filter out Items which contains only the Items with FLXXXXXX. :|
Have a Nice Day!

Comments

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    Did you try with SETFILTER?

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • Himanshu_Nigam
    Himanshu_Nigam Member Posts: 23
    Use the filter Like FL* and then find the record.
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Lalaka wrote:
    Hi,
    Is there anyway (function) to check if a character is included in a String.
    Ex: I have an Item Number List containing millions of items. One item is FL222104,another is RM112200.
    How can I filter out Items which contains only the Items with FLXXXXXX. :|

    Lalaka, be careful doing wild card filters on tables with millions of records. You may be better off creating a new field that stores the first 2 characters (FL or RM) and add an index to it. and do a direct setrange on that new field.
    David Singleton
  • Lalaka
    Lalaka Member Posts: 32
    David Singleton wrote:
    Lalaka wrote:
    Hi,
    Is there anyway (function) to check if a character is included in a String.
    Ex: I have an Item Number List containing millions of items. One item is FL222104,another is RM112200.
    How can I filter out Items which contains only the Items with FLXXXXXX. :|

    Lalaka, be careful doing wild card filters on tables with millions of records. You may be better off creating a new field that stores the first 2 characters (FL or RM) and add an index to it. and do a direct setrange on that new field.

    It looks safe :?
    Thank You :)
    Have a Nice Day!

Categories