LOWER macro

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

Syntax

LOWER(data)

Parameters

data

The string value to be converted to lowercase.

Description

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.