LOWER
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.
This macro is available in
IBM
®
Unica
®
Interact
.
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
.
Copyright IBM Corporation 2012. All Rights Reserved.