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 ()

XOR-LISTS Command (English) (m618305+xorlists.htm)

To	Reality
Version
Topic
Submitted by
Company
Location
Email address
Comment

XOR-LISTS

Returns a list comprising values contained only once in all the lists referenced. A value contained more than once in a list will not be returned.

Syntax

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

Syntax Elements

list-name The name of a saved list.

Options

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

:XOR-LISTS FIREALRM FIRESPKLR

9 Items selected.

>SAVE-LIST PHONECALL

[241] 'PHONECALL' Cataloged.

All values that appeared only once in both lists FIREALRM and FIRESPKLR are now in list PHONECALL.

:XOR-LISTS SMKR DRNK OVFF OVWT

7899 Items selected.

>SAVE-LIST ADVISE

[241] 'ADVISE' Cataloged.

The list in ADVISE contains all values that appeared only once in all the lists referenced in the XOR-LISTS command.