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.

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.

[ Back to top ]

ACL Scripting Guide 14.1