Options

NAV Function/Filter to do string checking

LalakaLalaka Member Posts: 32
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

  • Options
    mohana_cse06mohana_cse06 Member Posts: 5,504
  • Options
    Himanshu_NigamHimanshu_Nigam Member Posts: 23
    Use the filter Like FL* and then find the record.
  • Options
    David_SingletonDavid_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
  • Options
    LalakaLalaka Member Posts: 32
    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!
Sign In or Register to comment.