LOWER macro

The LOWER macro is available in IBM® Campaign and IBM® Interact.

The string value to be converted to lowercase.

LOWER converts each string value in the specified data range to lowercase. It returns a new column with each cell containg the lowercased string of the corresponding input cell.

Examples

Temp = LOWER "GOLD"

Creates a new column named Temp containing "gold".

TEMP = LOWER( "JAN 15, 1997")

Creates a new column named TEMP, which contains the ASCII text string " jan 15, 1997 ".

TEMP = LOWER( "Pressure")

Creates a new column named TEMP, which contains the ASCII text string "pressure".

TEMP = LOWER(V1)

Creates a new column named TEMP containing lowercase characters of each string in column V1.