Skip to main content

lowercase

Overview​

The lowercase statement is used to modify the name of, and/or the values in, a column such that any upper case characters are replaced with their lower case equivalent.

Syntax​

lowercase heading|values [and heading|values] in columnColName1 [... ColNameN]

info

Although the syntax shown uses the keyword column, either column or columns may be specified. Both work in an identical manner.

Details​

The heading and values keywords determine the scope of the processing to be applied. The columns named in ColName1 ... ColNameN may or may not be fully qualified. If a column name is not fully qualified then the default DSET will be assumed.

Only upper case characters in a column name or value are converted. Numbers, punctuation and other symbols are ignored. Any blank values in a column are ignored.

Examples​

lowercase heading in column servicegroup

lowercase heading and values in columns servicegroup VMWare.usage.resourcepool chargeinterval

lowercase values in column Region