Documentation Comments

Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.

Reality V15.0 ()

AND-LISTS Command (English) (m618305+andlists.htm)

To	Reality
Version
Topic
Submitted by
Company
Location
Email address
Comment

AND-LISTS

Returns a list comprising all attribute values contained in each of two or more lists, or n times altogether if specified, that is, the intersection of the lists.

Syntax

AND-LISTS list-name list-name {list-name}... {(options}

Syntax Elements

list-name The name of a saved list.

Options

n The number of times the attribute value must occur for inclusion in the list (the default is the number of items).

I Specifies that case should be ignored when comparing attribute values.

S Specifies that case is significant when comparing attribute values.

Comments

Uniqueness of values in a source list can be guaranteed by sorting the list with the SORT-LIST command and specifying the U option.

Only the first field (value or subvalue) is processed, all the other fields being discarded. The merged list therefore contains only the first field from each attribute.

Case Sensitivity

If neither I nor S is specified, the current data case setting (set with the DATA.CC environment option or the CASE TCL command) is used. See Case Sensitivity for more details.

If both I and S are specified an error message is displayed and no list is generated.

Examples

:AND-LISTS OVERDUE LARGEAMT

429 Items selected.

>SAVE-LIST PHONECALL

[241] 'PHONECALL' Cataloged.

All values that were in both lists OVERDUE and LARGEAMT are now in list PHONECALL.

:AND-LISTS SMKR DRNK OVFF OVWT

7899 Items selected.

>SAVE-LIST BIGRSK

[241] 'BIGRSK' Cataloged.

The list in BIGRSK contains all values that were in every list referenced in the AND-LISTS command.