### In String operator

Basic and Crystal syntax.

##### Usage

`x in y`

Tests for the presence of string x in string y.

##### Examples

The following examples are applicable to both Basic and Crystal syntax:

`"Elm" in {customer.ADDRESS1}`

TRUE, where {customer.ADDRESS1} is "1335 Elm Street".

`"Elm" in {customer.ADDRESS1}`

TRUE, where {customer.ADDRESS1} is "1335 Elmer Street".

`"elm" in {file.MOTTO}`

FALSE, where {file.MOTTO} = "Feel more energy".

(The "el" ending "feel" and the "m" beginning the word "more" are separated by a space which itself counts as an element.)

`"el m" in {file.MOTTO}`

TRUE, where {file.MOTTO} = "Feel more energy".

The search string "el m" this time contains the space between the l and the m, which allows for a perfect match.

Note: The "in" operator can also be used to test for the presence of a string in a text range. For example, "V5B" in "V0A" to "V9Z".

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com