NAV Function/Filter to do string checking

Lalaka

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.

mohana_cse06

Did you try with SETFILTER?

Himanshu_Nigam

Use the filter Like FL* and then find the record.

David_Singleton

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.

Lalaka

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