# Fields that Contain a Specified String

You can use the following field specifiers (case sensitive) to return documents with fields that contain a specified string.

## STRING

The `STRING` field specifier (case sensitive) allows you to specify one or more strings, of which one must be contained as a substring in a specified field.

    FieldText=STRING{yourStrings}:yourFields

where:

`yourStrings` | is one or more strings. A document returns only if one of these strings is a substring of the value in one of `yourFields`. FieldText queries that include commas and braces in the query have specific percent-encoding requirements. For information about percent-encoding, see FieldText.
`yourFields` | is one or more fields. A document returns only if it contains one of these fields, and if the value in this field contains one of `yourStrings` as a substring. If you want to specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=STRING{cat,dog}:ANIMAL

The `ANIMAL` field value must contain the substring cat or dog for the document to return. For example, if the `ANIMAL` field has the value scattering, the document returns.

    FieldText=STRING{old cat}:ANIMAL:TOPIC

The `ANIMAL` or `TOPIC` field value must contain the substring old cat for the document to return. For example, if the `ANIMAL` field has the value old cat, old caterpillar, or bold cats, the document returns.

    FieldText=STRING{example.com}:COMPANY

The `COMPANY` field value must contain the substring example.com for the document to return. For example, if the `COMPANY` field has the value example.com or http://www.example.com/content/home, the document returns.

    FieldText=STRING{a\,b}:MISC

The `MISC` field value must contain the substring a,b for the document to return. For example, if the `MISC` field has the value a,b or a,b,c, the document returns.

## STRINGALL

The `STRINGALL` field specifier (case sensitive) allows you to specify one or more strings, which must all be contained as a substring in a specified field.

    FieldText=STRINGALL{yourStrings}:yourFields

where:

`yourStrings` | is one or more strings. A document returns only if all these strings are substrings of the value in one of `yourFields`. If you want to specify multiple strings, separate them with commas (there must be no space before or after a comma). FieldText queries which include commas and braces in the query have specific percent-encoding requirements. For information about percent-encoding, see FieldText.
`yourFields` | is one or more fields. A document returns only if it contains one of these fields, and if the value in this field contains `yourStrings` as substrings. If you want to specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=STRINGALL{cat,dog}:ANIMAL

The `ANIMAL` field value must contain the substrings cat and dog for the document to return. For example, if the `ANIMAL` field has the value grooming cats and dogs or doggedly scattering seeds, the document returns.

    FieldText=STRINGALL{old cat,young dog}:ANIMAL:TOPIC

The `ANIMAL` or `TOPIC` field value must contain the substrings old cat and young dog for this document to return. For example, if the `ANIMAL` field has the value old cat chases young dog, or young doggedly chasing bold cats, the document returns.

    FieldText=STRINGALL{a\,b,e\,f}:MISC

The `MISC` field value must contain the substrings a,b and e,f for this document to return. For example, if the `MISC` field, for example, has the value a,b,c,d,e,f or 0=e,fx 1=da,ba, the document returns.

## SUBSTRING

The `SUBSTRING` field specifier (case sensitive) allows you to return documents whose field value is a substring of a specified string (or equal to a specified string).

    FieldText=SUBSTRING{yourStrings}:yourFields

where:

`yourStrings` | is one or more strings. A document returns only if one of `yourFields` contains a substring of one of the specified strings. If you want to specify multiple strings, separate them with commas (there must be no space before or after a comma). FieldText queries that include commas and braces in the query have specific percent-encoding requirements. For information about percent-encoding, see FieldText.
`yourFields` | is one or more fields. A document returns only if it contains one of these fields, and if the value in this field is a substring of `yourStrings`. If you want to specify multiple fields, separate them with colons (there must be no space before or after a colon).

Examples:

    FieldText=SUBSTRING{Telecommunications,Technology}:SECTOR

The `SECTOR` field must contain a string that is a substring of Telecommunications or Technology. For example, if the `SECTOR` field has the value Telecom or Technology, the document returns. If the `SECTOR` field has the value Latest Technology, the document does not return.

© 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