ANStrList functions

Set of functions to manage ANStrList strings, read, save, delete, sort, compare, count and create unique
ANStrList is one string having multiple items separated by known separator

Edit 2025-02-02: Adding ANStrCompare_AnyListItems to compare any items. Update List_Compare() to use Frequency() instead.

Functions:
List_ItemRead: To read item from list by its ID
List_ItemSave: Returns list after modifying certain item by its ID
List_ItemsModify: Returns list of items after adding or deleting items, preserving list uniqueness.
List_ItemsCount: returns count of items in list
List_ItemsSort: To sort list items in list alphabetically, using ADOR.Recordset object
List_ItemSearch: searching for an item in list
List_ItemsUnique: Returns list of unique items in list
List_Compare: Compares between two ANStrlists, returns 1 if match, 0 if not, with option to compare order too or not
AnStrCompare_AnyListItems: Compare any item from a list into another, returns 1 if at least 1 match found, 0 if none

CodeFunctionName What is this?

Public

Tested

Original Work

Access is limited.

Login here using your Linkedin account. to see or download code.

No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Bold.codes

Linkedin Login

Varies, but mostly
ANStrList, Sepa
or
ANStrList1, ANStrList2, Optional CompareOrder = 0, Optional Sepa = "|"

Views 5,090

Downloads 1,575

CodeID
DB ID