MULT_RANGE comparison

Required Columns

The following data source and reference source columns are required.

• Data. The character string from the data source.
• Reference. The character string from the reference source.

Example

Each range must be separated by a pipe symbol (|). The tilde (~) is used to indicate the ranges, since the hyphen might be a legitimate address suffix (123-A). The prefix "B:" can be used to signify both odd and even numbers in the range. Otherwise, the parity of the low number is used.

101~199 | B:201~299|456|670 ½| 800-A~898-B|1000~

The following ranges result from the previous example.

101 to 199 odd numbers only
201 to 299 both odd and even number
456 (the one house number only)
670 ½ (the one house number only)
800-A to 898-B even numbers only
All even house numbers 1000 or greater.