# 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 specified by you.

NOTE: You can optimize the field specifier speed by restricting the field to the MatchType property type.

## Format

    FieldText=ARANGE{yourTerms}:yourFields

`yourTerms` | Type 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 full stop (`.`) in place of one of the terms, to represent an unrestricted value. Use the full stop in place of the first term to include all values up to the second term. Use the full stop in place of the second term to include all values after the first term. NOTE: IDOL Server uses unicode tables to determine alphabetical order. This means that non-7-bit ASCII characters (ä, å, ç, d, ê, ë, ø, ö, ü, û, ß, ÿ, and so on) come after z in the alphabet.
`yourFields` | Type 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`. Separate multiple fields with colons (`:`). There must be no space before or after a colon.

## Example

    FieldText=ARANGE{aardvark,alligator}:ANIMAL

The `ANIMAL` field must contain a value that alphabetically falls between `aardvark` and `alligator`. A document returns if the `ANIMAL` field contains the value `aardvark`, `ant`, `anteater`, `antelope` or `alligator`. 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`. A document returns if the `ANIMAL` or `TIER` field contains the value `bear`, `bee`, `Biene`, `bird` or `buffalo`. 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 2020 Micro Focus or one of its affiliates | Send documentation feedback Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a mail client, and then send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm