![]() Tabular data handling toolkit |
Comma-delimited listsA comma-delimited list (or "list" for short) is a list of items, delimited with commas. A list is stored as a single alphanumeric variable or field. Individual members cannot contain embedded commas. Embedded whitespace is allowed within or outside of individual list members (the list may need to be quoted).An example: Harry,Ron,Hermione Lists are most suitable where individual values are known to be small in size (such as controlled-vocabulary tags or integer id numbers) and where it is known that there will not be a huge number of choices. The total length of a comma-delimited list is limited to 250 characters. Lists allow a set of values to be manipulated as a unit, which is often convenient. They can be used within conditional expression operators such as IN, INRANGE, and CONTAINS. Some functions also work with lists.
|
![]() Tabular data handling toolkit Copyright Steve Grubb |