IDOL Community Component 12.13

# Fields whose Value Falls within a Specific Alphabetical Range

## ARANGE

The `ARANGE` field specifier (case sensitive) allows you to find documents in which a specified field contains a term that falls within the inclusive alphabetical range of two terms that you specify.

    FieldText=ARANGE{yourTerms}:yourFields

where:

`yourTerms` | is two terms separated by a comma (there must be no space before or after the comma). A document returns only if one of `yourFields` contains a term that falls within the inclusive alphabetical range of the specified terms. You can use a period (.) in place of one of the terms to represent an unrestricted value. If you use the period in place of the first term, it includes all values up to the second term. If you use the period in place of the second term, it includes all values after the first term. It uses unicode tables to determine alphabetical order. This means that non-7-bit ASCII characters (α, ä, å, ç, δ, ê, ë, ø, ö, ü, û, ß, ÿ, and so on) come after z in the alphabet.
`yourFields` | is one or more fields. A document returns only if it contains one of these fields, and if this field contains a term that falls within the inclusive alphabetical range of `yourTerms`. To specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=ARANGE{aardvark,alligator}:ANIMAL

The `ANIMAL` field must contain a value that alphabetically falls between aardvark and alligator. If the `ANIMAL` field contains the value aardvark, ant, anteater, antelope, or alligator, the document returns. If the `ANIMAL` field contains the value armadillo, it does not return.

    FieldText=ARANGE{bear,buffalo}:ANIMAL:TIER

The `ANIMAL` or `TIER` field must contain a value that alphabetically falls between bear and buffalo. If the field contains the value bear, bee, Biene, bird, or buffalo, the document returns. If the `ANIMAL` field contains the value Büffel or chipmunk, it does not return.

    FieldText=ARANGE{dog,.}:ANIMAL AND ARANGE{.,cat}:PET

The `ANIMAL` field must contain a value that alphabetically falls after dog, and the `PET` field must contain a value that alphabetically falls before cat.

© Copyright 2022 Micro Focus or one of its affiliates
Version 12.13 | Last updated October 2022

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to swpdl.idoldocsfeedback@microfocus.com.

We appreciate your feedback!

Product: IDOL IDOL Community Component 12.13

Topic Title: Fields whose Value Falls within a Specific Alphabetical Range