Filter according to the length of string

Business Central/NAV User Forum
1

Hello,

I’d like to know if is it possible to filter the Items according to their description’s length.

For example : show only items which lenght of description is lower then 5 characters ?

Thank you for your help.

2

Hi Raf,

Well no direct filter like SETMAXSTRLENFILTER or similar exists. What you have to do is use the good old STRLEN to test the length of the description. So you need to create code smilar to this if you need this in code:

IF Item.FINDSET THEN
REPEAT
Item.MARK(STRLEN(Item.Description) < MyMaxStrLen);
UNTIL Item.NEXT = 0;
Item.MARKEDONLY(TRUE); // Will set the filter to only show marked items

If in a report then you would have to do the test for each record and say if it is to be printed or not.