Search, replace

Search functions let you perform different types of searches. You can search data for specific words or sequences of characters, values within a range, blank values, and values matching a pattern.

Replace functions give you different options for searching and replacing data.

Tip

For numerous examples of using functions to perform powerful and effective searching and filtering of data in tables, see Search and filter using Analytics functions.

Function descriptions

Function Description

AT( )

Returns a number specifying the starting location of a particular occurrence of a substring within a character value.

BETWEEN( )

Returns a logical value indicating whether the specified value falls within a range.

CLEAN( )

Replaces the first invalid character in a string, and all subsequent characters, with blanks.

FIND( )

Returns a logical value indicating whether the specified string is present in a particular field, or anywhere in an entire record.

FINDMULTI( )

Returns a logical value indicating whether any string in a set of one or more specified strings is present in a particular field, or anywhere in an entire record.

ISBLANK( )

Returns a logical value indicating whether the input value is blank.

MAP( )

Returns a logical value indicating if a character string matches a specified format string containing wildcard characters, literal characters, or both.

MATCH( )

Returns a logical value indicating whether the specified value matches any of the values it is compared against.

OCCURS( )

Returns a count of the number of times a substring occurs in a specified character value.

REGEXFIND( )

Returns a logical value indicating whether the pattern specified by a regular expression occurs in a string.

REGEXREPLACE( )

Replaces all instances of strings matching a regular expression with a new string.

REPLACE( )

Replaces all instances of a specified character string with a new character string.

TEST( )

Returns a logical value indicating whether a specified string occurs at a specific byte position in a record.