$squeeze

Builds a single character string out of separate strings, inserting a separator string.

Syntax

$squeeze(separator«,string»)

Parameters

separator

A character string, or an expression that evaluates to a character string. Separator is placed between each instance of string.

string

A character string, or an expression that evaluates to a character string. Leading and trailing blanks are trimmed from string. Each string must be separated from the next by a comma.

Return Value

Character string.

Comments

$squeeze combines specified strings into a single string, with separator placed between each string. In the function call, each string must be separated from the next by a comma. Leading and trailing blanks are trimmed from each string.

Example

$squeeze (",",LastName,FirstName,Salutation)

Evaluates to "Smith,John,Mr." when FirstName is "John ", LastName is "Smith ", and Salutation is "Mr. ".

list all Ents format $squeeze ("",EntName,EntType,AvgSize,DirName)

Compresses the LIST output as much as possible.

Related Information

$concat

$delete

$insert

$left

$position

$replace

$right

$substring

$translate

About Functional Expressions

About Character Literals