LOOKUP

Lookup an item within a List of items.

This will not locate a UDB List Object within a List. Only Items.

Number	Name	Default	Type	Description
1	item		String	Item, or list of items, to Look for
2	list		String	List to Look in eg.[1:Yes,0:No] It doesn't matter if the list is enclosed in square brackets or not.
3	list_type	0	Integer	The type of list. 0 = UDB list [a:1,b:2] 1 = URL list [a=1&b=2] 2 = The ID of a UDB List object to search. Part 1(Character 1) is searched. Use 21 to return Part 1 of the located Object Use 22 to return Part 2 of the located Object 3 = Comma separated list (first element is item 1) 4 = Space separated list (first element is item 1) 5 = Pipe separated list (first element is item 1)
4	default		String	The default value to use if nothing is found

<!-- Command Lookup -->

{LOOKUP(ABS, 1048, 2)}

5947

{LOOKUP(3, [1:One, 2:Two, 3:Three])}

Three

to add a Comment.

ULTIMATE DATABASE